Delete from table one using criteria of another table

[Tock]

I am trying to delete rows from table one when values equal values in table two. I cannot find an example. Can someone help?

 

[pankajv]

DELETE TAB1
FROM TAB1 T1
INNER JOIN TAB2 T2
ON T1.Value = T2.Value

Thanks,
Pankaj

 

[iker3000]

DELETE FROM TAB1 WHERE TAB1.Value IN (SELECT DISTINCT TAB2.Value FROM TAB2)

(Distinct is only good if Tab2 contains many rows but the given column is not very diversified)

Iker