Delete?

[dan]

Hi,

I have a table like this:

ColA ColB
22 Drink
22 Eat
22 Spill
23 Drink
23 Eat
24 Drink
24 Spill


I want to delete all records for a number where ColB = Spill. For
example, since 22 has a Spill Entry and 24 has a spill entry, it would
delete all rows where ColA has 22 and where ColA has 24. I'm guessnig a
SQL query would do this?

Any help is very appreciated!! Thanks!

 

[ChrisM]

Hi Dan,

Do you mean

DELETE * FROM myTable outerLoop
WHERE EXISTS
(
SELECT * FROM myTable innerLoop
WHERE innerLoop.ColB = "Spill"
AND innerLoop.ColA = outerLoop.ColA
)

?

Cheers,

Chris.

 

[Pieter Wijnen]

DELETE FROM TheTable WHERE ColB='Spill'

Pieter

Hi,

I have a table like this:

ColA ColB
22 Drink
22 Eat
22 Spill
23 Drink
23 Eat
24 Drink
24 Spill


I want to delete all records for a number where ColB = Spill. For
example, since 22 has a Spill Entry and 24 has a spill entry, it would
delete all rows where ColA has 22 and where ColA has 24. I'm guessnig a
SQL query would do this?

Any help is very appreciated!! Thanks!

--

 

[ChrisM]

No!
I very nearly posted that, then I read his question more carefully...

Cheers,

Chris.

"Pieter Wijnen"

 

[Pieter Wijnen]

Errare humanum est

Pieter

No!
I very nearly posted that, then I read his question more carefully...

Cheers,

Chris.

"Pieter Wijnen"

--