Delete using inner join

[j252ewv]

Con some clever sole point out the error in the following delete script please:

delete from subscriptionmembers
inner join contacts on Contacts.contactid = subscriptionmembers.contactid
where
contacts.categorycode in ('CPAT','NMP','PAT','DEN','PRAC','DOC','TEA')

I get the error

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'inner'.

 

[bborissov]

You should double FROM clause:

delete from subscriptionmembers
from subscriptionmembers
inner join contacts on Contacts.contactid = subscriptionmembers.contactid
where contacts.categorycode in ('CPAT','NMP','PAT','DEN','PRAC','DOC','TEA')

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[j252ewv]

Your right! I knew it was something simple!!

Many thanks.