Delete Query?

E

Ed

I used the 'Find Unmatched Query Wizard' to create a qurey.
It worksd great!
I want to use that qurey results to delete the records from the table.
How do I select the table to delete from?

SELECT DISTINCTROW tblSignalsCal.SIGID
FROM tblSignalsCal LEFT JOIN qrySignalsCalculated ON tblSignalsCal.SIGID =
qrySignalsCalculated.SIGI
WHERE (((qrySignalsCalculated.SIGI)=""));
 
J

Joris Dobbelsteen

See Jet SQL Syntax.

DELETE FROM <table>
WHERE <condition>

E.g.
DELETE FROM tblSignalsCal
WHERE NOT EXISTS
(SELECT *
FROM qrySignalsCalculated
WHERE qrySignalsCalculated.SIGI = tblSignalsCal.SIGID
)

[Of course a good SQL database should understand, Access should so too]

- Joris
 
Top