Re: How to delete from table1 where (table1.field1=table2.field2)

delete from table1
where primarykeycolumn in (select primarykeycolumn from table2)

brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0205091959.35ec3fe7_at_posting.google.com>...
> How to delete from one table where one of the fields equals to a field
> in another table?
Received on Fri May 10 2002 - 17:26:45 CEST

This message: [ Message body ]
Next message: piyush rampuria: "Re: How to delete from table1 where (table1.field1=table2.field2)"
Previous message: Bhooshan Prabhu: "Re: How to delete from table1 where (table1.field1=table2.field2)"
In reply to konghou: "How to delete from table1 where (table1.field1=table2.field2)"
Next in thread: piyush rampuria: "Re: How to delete from table1 where (table1.field1=table2.field2)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]