Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Delete statement

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-06-30 : 17:19:59
How to convert Access delete query to SQL statement?

DELETE A.*
FROM A INNER JOIN B ON A.CODE = B.CODE

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-30 : 17:23:59
DELETE a
FROM TableA AS a INNER JOIN TableB AS b ON b.CODE = a.CODE



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -