select query problem

[gazzy3k]

i have a query based on 3 tables, 2 tables (table 1 & 2)contain 10k records each, the 3rd tables (added very recently) only contains 3k records.
My problem is that when i run a query to show all relevant data from the 3 tables it only will show the most recent records (the 3k from the new tables) if i remove table 3 it will show all 10k records..

i need the full query to include the 10k records. it is a basic query with no criteria at all.

 

[FoFa]

If in query designer, click the JOIN line to table3 and select the proper join method, or if in SQL, use a LEFT or RIGHT (depends on table order) join on table3 instead of an inner join.