Board index » delphi » RIGHT OUTER JOIN different in Delphi 2 / BDE32

RIGHT OUTER JOIN different in Delphi 2 / BDE32

I am running exactly the same query on one table using Delphi 1 / BDE16 and
Delphi 2 / BDE32, on Delphi 2 / BDE32 the result in ridiculously wrong....
Has anybody found this before ????

The query is:

SELECT CASH001.* , CASH001.*
FROM CASH001 a right outer join CASH001 b on a.BtRecParent = b.PrimIndex
where a.BtRecType <> 3

The cash001.db is attached.

Regards
Johan

 

Re:RIGHT OUTER JOIN different in Delphi 2 / BDE32


Sorry, my mistake, I didn't post the tables the first time.

Johan van der Spuy <brill...@iafrica.com> wrote in article
<01bc0c4b$3ba28b40$82961fc4@johan_pc>...

Quote

> The cash001.db is attached.

> Regards
> Johan

begin 600 Cash001.zip
<uuencoded_portion_removed>
64$L%!@`````&``8`5 $``,(&````````
`
end

Other Threads