Built with Grav - The Modern Flat File CMS
SELECT ... FROM table1 LEFT OUTER JOIN table2 ON table1.table2id = table2.id ORDER BY whatever