Deleting from a list.

Hi;

I am still improving my sql/tsql skills.

I was wondering if someone could give me some advice on how to do some
high powered deletes.

I have two tables, A and B.

"A" is the table I want to delete records from.

"B" is a table where each record is 4 keys ( fields ) that I want to
match with one or more records in "A" to remove.

Could I accomplish this with something like

delete from A ( select ... from B ) ?

SteveHi

Books online should be the first option when wanting to find out information
regarding syntax etc. and example D on the delete definition page gives you
exactly what you want.

http://msdn.microsoft.com/library/d...asp?frame=true

John

"Steve" <stevesusenet@.yahoo.com> wrote in message
news:6f8cb8c9.0310311713.1be6dc2e@.posting.google.c om...
> Hi;
> I am still improving my sql/tsql skills.
> I was wondering if someone could give me some advice on how to do some
> high powered deletes.
> I have two tables, A and B.
> "A" is the table I want to delete records from.
> "B" is a table where each record is 4 keys ( fields ) that I want to
> match with one or more records in "A" to remove.
> Could I accomplish this with something like
>
> delete from A ( select ... from B ) ?
> Steve