var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Outer joins
I need to use an outerjoin to join 2 tables but they need to be joined based on 2 colums.
so they need to be joinen basen on col1 and col2
from tablea a
left outer join tableb b
on a.col1 = b.col1
the rest i'm unable to find... could someone help me with this?
SELECT ... FROM TBLA A LEFT OUTER JOIN TBLB B ON B.COL1 = A.COL1 AND B.COL2 = A.COL2 WHERE ...
This is one alternative ...
Beware of the keyword AND in JOIN conditions versus using the WHERE clause.