Re: Not IN or Where Not Exists in subquery?
- From: "Neil" <nrgins@xxxxxxxxx>
- Date: Mon, 2 Feb 2009 09:59:05 -0600
"timmg" <tmillsgroninger@xxxxxxxxx> wrote in message
news:740784bd-8f8f-49aa-90f3-96492b30f40e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You might try creating a subquery that identifies the records you wish
to exclude, then do a left join to that pulling only the nulls. It
may not be the most eloquent solution, but it's easy to
troubleshoot.
I'm not sure that Access/Jet support "Exists"
HTH,
tim
============================
Jet does support Exists. But it's just as easy to do a left outer join. But
no subquery necessary.
Neil
.
- References:
- Not IN or Where Not Exists in subquery?
- From: circuit_breaker
- Re: Not IN or Where Not Exists in subquery?
- From: timmg
- Not IN or Where Not Exists in subquery?
- Prev by Date: Re: access 2007 and forms in data*** view
- Next by Date: Re: access 2007 and forms in data*** view
- Previous by thread: Re: Not IN or Where Not Exists in subquery?
- Next by thread: Re: Not IN or Where Not Exists in subquery?
- Index(es):
