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

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?

first, if you are trying to delete a field that is foreign key of another table and you have all your constraints enabled. then you won't be able to delete that field without doing appropriate modifications.

Second, The questions is do you want to delete the field along with the data or simply the data contained in a that field?

Anyways heres my solution

alter table drop column column_name;

delete Received on Fri May 10 2002 - 23:17:09 CEST