tables linked in a query

[Jackske]

I have a main table and 2 sub tables which are linked to the main table.
I put all of them in 1 query.
The query shows me only those record where some data are also inserted in the sub tables. That is NOT my wish.
I want this query to show me all records even if there are no data's for this record in 1 or both sub tables!

Thanks for your help


Jackske/Belgium

 

[Kodo]

you need to use an outer join

 

[Jackske]

soory if I am abusing

Sorry, if I am abusing but what is an Outer Join?

Jackske/Belgium