Greetings again,

I want to delete some records such as:

DELETE FROM TABLE WHERE ID IN (<..various ids>)

So far so good, however, I want to combine where clause to soem other condition on other table...
like DELETE FROM TABLE t1 WHERE t1.ID IN (<..various ids..>) AND t1.DATE < (SELECT t2.ZDATE FROM ANOTHERTABLE t2 WHERE t2.ID = t1.USER )

Will that work? (Don't want to delete any other records on other table)

Something like this?

I guess I made it like similiar to first post... not sure if Inner Join would not mess up on delete

I did it like

DELETE FROM TABLE WHERE ID IN (...) AND DATE < (SELECT OTHERDATE FROM ANOTHERTABLE AS AT WHERE AT.ID = USER)

Ofcourse, only thing stopped me doing it was Collations and when fixing collations, it is all done, voila...

Edit: Woha, over 500 posts after years :p I'm a slacker....

Using inner join as I typed it will not affect the second table. But if you've got it functioning and are happy with it, that's all that counts.