How would I select all the data from two tables where the id of one table matchs the other, but if nothing matchs in the second for it to return null for the columns in that table?
SELECT t1.id as id FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.id = t2.relationField ORDER BY t1.id ASC
