Specify table you want to delete records from

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

Other Forums

MS Access

Specify table you want to delete records from

Author

Topic

Trudye
Posting Yak Master

169 Posts

Posted - 2008-10-16 : 07:31:40

Hi Guys, anyone seen this one before?
Getting msg: Specify table you want to delete records from

DELETE Account_Num
FROM DSNB_Sp INNER JOIN LTR_3A_Status ON DSNB_Sp.Account_Num = LTR_3A_Status.F1
WHERE LTR_3A_Status.f2 = "C"

Thanx,
Trudye

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-17 : 00:17:18

Not sure about Access syntax, but try this:

DELETE d
FROM DSNB_Sp d
INNER JOIN LTR_3A_Status l
ON d.Account_Num = l.F1
WHERE l.f2 = 'C'

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources