469,080 Members | 1,722 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,080 developers. It's quick & easy.

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 ) ?

Steve
Jul 20 '05 #1
1 1374
Hi

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/de...asp?frame=true

John

"Steve" <st**********@yahoo.com> wrote in message
news:6f**************************@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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.