SELECT t1.username, t1.email, t2.* FROM table1 t1 JOIN table2 t2 ON t1.username = t2.username WHERE t1.username = 'user1'; Share Edit Follow