case-sensitive Left Join

[Lakshman]

From the Microsoft site, I'm able to het help on how to
perform a case-sensitive match on an equi join (inner
join).

Can some one help me out on how to do a left join case-
sensitive query?

Example: Table_A has a field f1 that has values like ABC.

Table_B has a field f2 with values like abc and ABC.

I want to do a join that gets me all the data from Table_A
and the matching ones from Table_B by doing case-sensitive
join on the 2 tables.

Appreciate your help.

 

[david epsom dot com dot au]

Use the words LEFT JOIN instead of 'INNER JOIN'

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244693
HOWTO: Perform a Case-Sensitive JOIN Through Microsoft Jet


(david)