Prev: search with multi values and get resaults order
Next: access 2007 use the old query builder format
From: John Spencer on 26 Dec 2009 13:09
Great. Glad you got this to work.

There is usually more than one way to get the desired results.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Sue Compelling wrote:
> Hi John
>
> Thanks for your efforts - I managed to find a similar post and John Vinson
> recommended the Query Wizard - "Unmatched Records" - this was perfect for
> what I wanted. I couldn't get the right join to work when I was doing it
> myself because I wasn't putting null in the criteria for the "not wanted
> records".
>
> Cheers
From: PieterLinden via AccessMonster.com on 27 Dec 2009 17:36
John Spencer wrote:
>Great. Glad you got this to work.
>
>There is usually more than one way to get the desired results.

FWIW, I try to NEVER use IN/NOT IN with large datasets. Performance is
*awful*. You're much better off learning how to do outer joins and using
indexed columns in the join.

SELECT *
FROM tableA LEFT JOIN tableB ON tableA.PrimaryKeyField = tableB.
ForeignKeyField
WHERE tableB.ForeignKeyField IS NULL

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200912/1

First  |  Prev  | 
Pages: 1 2 3
Prev: search with multi values and get resaults order
Next: access 2007 use the old query builder format