Access query

[timboellis]

I have a vary large 200m database with over 200 tables however I need to create a CSV, XLS of a selection of the tables however the issue is this.



If I just now quote 2 of my tables called Coredetails and occupationdetails.

If I do a query on the coredetails this given me 3075 results.

If I do a query on occupationdetails this gives me 2366 results

however if i combine the details this gives me 2366 results.

However I want all the results so expecting 3075

can someone advise what i am doing wrong here or how to get all the results.

I am looking to get info out of approx 5 different tables , some tables will have no info for certain clients and others will

Thanks for any help

[RuralGuy]

The default for the query builder is an INNER JOIN which requires data in both tables for selection. Change to an OUTER JOIN (Left or Right) and you should get the results for which you are looking.