ADOQuery - SQL Outer Join Problem

Hi,

I've little problem with SQL in a ADOQuery Component

I want ALL records from one table, and related records from another
table.

In ANSI SQL it is something like this :

SELECT *
FROM tblFirst A, tblSecond B
WHERE A.PrimKey(+) = B.ForeignKey;

The ADOQuery component refuses to accept '(+)', which is used in ANSI
SQL to perform an outer join ...

Is there anyone out there who can tell me how to perform an outer join
with ADOQuery ??

Thanks
DD

Sent via Deja.com http://www.deja.com/
Before you buy.