Subject Need an example
Author Jose Gomez
Hi, I've been trying to make a DELETE statement with no success, I'm moving
from DAO / BDE to IBO. D6 & IB6

How can I do a DELETE with an INNER JOIN in IBO?

I need to delete from one table
Here's what I have:

DELETE
FROM Mov_CxP
INNER JOIN ConceptB ON (Mov_CxP.Mov_Type = ConceptB.Mov_Type)
WHERE ( ( ConceptB.Catalog = 'CXP' ) AND ( Mov_CxP.XDate > :DIni ) );

It's supposed to delete from table MOV_CXP

Any help will be greatly appreciated...