lundi 13 juillet 2015

Ineer join don't work good in sql "near "INNER": syntax error" [duplicate]

This question already has an answer here:

this code was work great from me in the past but today it's not work

i got error of: near "INNER": syntax error:

DELETE
FROM n2Detail
INNER JOIN n2Item b
on n2Detail.ItemID = b.ID
Where b.Expires IS NOT NULL

what is the problem? is there new version of sql?

Aucun commentaire:

Enregistrer un commentaire