| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Access data -work in Excel- save in Access | Excel Programming | |||
| Getting Access Error Messages when running Access through Excel | Excel Programming | |||
Hybrid Mode
