query problem

[eran3185]

hey again...
i try to build a query based on table and some other queries.
when there was only a table - it was ok (all the records were in my query).
but when i combine some queries - it wasn't ok... i didn't see all the records.
why ???

[geekgirlau]

You need to look at the relationship between your tables. Depending on the type of join, you are probably only seeing data where the joined fields match in both tables.

[asingh]

Hi,

Be carefull about the type of join..you choose between 2 tables and/or queries. The Top option will give you all records from the left table/query and also the matched records from the right side. The middle option will only give the matched values. And the Bottom option, will return all values from the right table/query and the matches from the left one..!