SELECT a.this, b.that FROM a, b WHERE a.id = b.a_id;
it just implies SELECT ... FROM a LEFT JOIN b ON(true) WHERE ...