More Excel VBA and Access
 

While constructing my SQL query in Excel VBA to bring in data from my access
DB......I need to know how to properly write the sql that do the same as
writng a LEFT JOIN sql query.....
I don't like to use left join, right join.......so how would I write it so
it brings in all records from one and only where they match from another?

More Excel VBA and Access
 

Sorry, SQL doesn't provide an alternative for those who don't like to use
LeftJoin, RightJoin.

--
George Nicholson

Remove 'Junk' from return address.


"ibeetb" wrote in message
...
While constructing my SQL query in Excel VBA to bring in data from my
access DB......I need to know how to properly write the sql that do the
same as writng a LEFT JOIN sql query.....
I don't like to use left join, right join.......so how would I write it so
it brings in all records from one and only where they match from another?