Crystal Reports

Crystal Reports

Post by Mike Clar » Thu, 20 Sep 2001 01:35:01



I'm using CR 8.5 and Informix 7.31.  I'm trying to do a self join for a
report.  I got the sql in informix to work fine, but I cannot find how
to do a self join in CR.  There is no reference to Self Join in the CR
online help files and my communication with Crytsal Decisions is that I
need to alias the table.  Having done this and tried numerous linking
schemes between the aliased table and non-aliases table, I get ODBC
errors when I run the report.

Has anyone done this successfully?