I haven't tried this exact syntax, but try this:

delete from mov_cxp
where
XDate = :DIni and
mov_type in (select distinct mov_type from conceptb where catalog = 'CXP')
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Jose
Gomez
Sent: Wednesday, January 16, 2002 7:56 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Need an example


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...





Yahoo! Groups Sponsor
ADVERTISEMENT





___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.

___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]