joins producing unexpected number of records

[Darth Vodka]

i have a table with 3740 records in it

i do a query and outer join this table with a query and it produces LESS records = 3733



now i always assumed (never assume it makes an "ass" out "u" and "me" !) that the records would be the same as the table you were joining from, obviously i've assumed wrongly, but why?

the query i'm using as my lookup query is grouped and i think that is causing me problems...if i turn it into a table, it works as expected



and i check the obvious: no filters or SELECT DISTINCT...

any suggestions/explanations welcome

 

[Guus2005]

Difficult to say without having the actual query and data. If you are using an UNION query, make sure that you use UNION ALL.

 

[Darth Vodka]

Difficult to say without having the actual query and data. If you are using an UNION query, make sure that you use UNION ALL.

thought of that too (only recently found out about that)

the query is was joining to was grouped and linked back to an ODBC source and i think that was confusing it...

i just turned it into a table and it worked

haven't got a clue why though!

 

[Guus2005]

thought of that too (only recently found out about that)

the query is was joining to was grouped and linked back to an ODBC source and i think that was confusing it...

i just turned it into a table and it worked

haven't got a clue why though!

That makes two of us.