DELETE SEVERAL ROWS

[mireles10]

First of all, I want to apologize if this is a duplicate post. I believe I post the question but I could not find it.
Using Sybase 12.5 on Windows Server 2003

I have 2 tables X, and Y
1. use a select statement to find out some values from the X table. Several values are return
A
B
C
..n

Now I write DELETE statement to delete every row

DELETE from Y where columnName = A
DELETE from Y where columnName = A
DELETE from Y where columnName = n

Is there a better way to do this?
Any sample of store procedure StoreProcedure (variable)?

Once the row is deleted, DO I need to run DBCC?
Thank you in advanced.

 

[PDreyer]

Use the same join in the delete

delete y
from  x
join  y
  on  x.key=y.key
where ...

 

[PDreyer]

Once the row is deleted, DO I need to run DBCC?

No, that is unnecessary.