Hi

I need to use an outerjoin to join 2 tables but they need to be joined based on 2 colums.

tablea: tableb:
col1 col1
col2 col2
col3 cola
col4 colb
... ...


so they need to be joinen basen on col1 and col2

select count(*)
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?

regards

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.

---