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?