SELECT table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.textid = table2.textid WHERE table1.userid = 1