Hello,
I have the following SELECT Statement working:
SELECT * FROM NDTab AS C
WHERE StatusTab = '1'
AND StatusView = 'A'
AND StatusExport = 'N'
AND NDTicket LIKE '%FNB%'
AND EXISTS (SELECT * FROM PSTab AS O
WHERE O.NDTicket = C.NDTicket
AND LData LIKE '%;Started ;%')
Now I want to do similar with the DELETE Statement:
DELETE FROM NDTab AS C
WHERE StatusTab = '1'
AND StatusView = 'A'
AND StatusExport = 'N'
AND NDTicket LIKE '%FNB%'
AND EXISTS (SELECT * FROM PSTab AS O
WHERE O.NDTicket = C.NDTicket
AND LData LIKE '%;Started ;%')
But I get the error: SQL logic error or missing database near "AS": syntax error
Can someone help me please how to make the DELETE Statement working?
Regards
CSN22