how to join more than 1 table so that i can check for user name and password for login purpose.

Question

how to compare username in 2 table with single query

Answer 1

SELECT username.tableA, username.tableB FROM tableA, tableB WHERE username.tableA = username.tableB ;

--use your own conditions after WHERE keyword