SQL Statement 1

[brians0friends]

For example sake I have put numbers within () to better explain my needs.


I need to sort table(1) by field(3) then compare SSN in field(1)from table(1) to table(2) field(2, also containing SSN). If match, in table(2), then delete entire row containing matching SSN in table(2).

 

[tlbroadbent]

Use SQL statements which handle this without the procedural steps - sort, match, delete... You can do everything with one SQL statement because SQL works on Sets of data.

Delete table2.*
From table2 Inner Join table1
On table2.field2=table1.field3;

Alternate statement:

Delete table2.*
From table2
Where field2 In (Select field3 From Table1); Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.