Subject | Need an example |
---|---|
Author | Jose Gomez |
Post date | 2002-01-16T15:55:47Z |
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...
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...