Re: query returning records that have no related recods in another table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
Date: Wed, 17 May 2006 06:47:42 -0400

SELECT * FROM Table1
WHERE NOT EXISTS (SELECT * FROM Table2 WHERE Table1.FK = Table2.PK)

--
Andrew J. Kelly SQL MVP

"Sagaert Johan" <REMOVEsagaert_j@xxxxxxxxxxx> wrote in message
news:O6R0puYeGHA.764@xxxxxxxxxxxxxxxxxxxxxxx

Hi

How is it possible to run a query that returns a recordset of records that
have no related record in another table ?

Johan

References:
- query returning records that have no related recods in another table
  - From: Sagaert Johan

Prev by Date: query returning records that have no related recods in another table
Next by Date: Re: Column Encryption
Previous by thread: query returning records that have no related recods in another table
Next by thread: RE: Alias Name for Dynamic Tables
Index(es):
- Date
- Thread

Relevant Pages

Re: Help with Microsoft help on linking Access to Outlook
... Tools - references - tick Microsoft Outlook object library. ... in the criteria cell in the graphical query builder. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
(microsoft.public.access.formscoding)
Re: Help with Microsoft help on linking Access to Outlook
... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
(microsoft.public.access.formscoding)
Re: Help with Microsoft help on linking Access to Outlook
... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
(microsoft.public.access.formscoding)
Re: Help with Microsoft help on linking Access to Outlook
... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... normal form to allow the normal filtering process and viewing of the ...
(microsoft.public.access.formscoding)
Re: Help with Microsoft help on linking Access to Outlook
... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
(microsoft.public.access.formscoding)