D7: BDE Local SQL Left Outer Join doesn't work ??


2004-04-27 10:59:09 PM
delphi35
select c.CustNo, o.OrderNo
from customer c left outer join orders o
on (o.CustNo = c.CustNo)
where o.OrderNo = 1003
The above is a simple outer join query run against tables in DBDemo(, so we
can all follow along).
I ran this sql in the DBDesktop the ships with D7.
I should get back all customer rows not just the Order matches...
I only get back the one row.
Can someone confirm this isn't working correctly?
Or is there an alternative syntax I should be using? I pulled the above
syntax write out of the LocalSql help example:
e.g.
SELECT *
FROM customer C
LEFT OUTER JOIN orders O
ON (C.custno = O.custno)