left
,outer
 join
 on WHERE where AND(right
, *=  =*  AND