SELECT *
FROM table1
JOIN table2
WHERE
(
    table1.username = 'user1'
    OR table2.username = "user1"
) AND
(
    table1.password = 'pass1'
    OR table2.password = 'pass1'
);