what is wrong w/ join syntax?

[equus2]

Hi,

DELETE FROM table1 tr
JOIN table2 trs
ON tr.BusinessDate = trs.BusinessDate

error next to "tr" - what am i doing wrong?

 

[RiverGuy]

Try this:

DELETE tr 
FROM table1 tr
JOIN table2 trs
ON tr.BusinessDate = trs.BusinessDate

 

[k01]

It will work on only SQLServer

DELETE FROM table1 FROM table2
WHERE table1.BusinessDate = table2.BusinessDate


koichi

http://aboutabi.blogspot.com/