LEFT EXCEPTION JOIN

[pchrysson]

Below is a description of a type of join available in iSeries DB2 SQL. I want to perform this same function in Access, but it doesn't seem to like the EXCEPTION.

Any ideas how I could accomplish this in Access?


"LEFT EXCEPTION JOIN and EXCEPTION JOIN
The result of T1 LEFT EXCEPTION JOIN T2 consists only of each unpaired
row of T1, the concatenation of that row with the null row of T2. All columns
derived from T2 allow null values.

 

[PHV]

FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field2
WHERE T2.Field2 Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244