UNION and PROJECT in ISQL

> I have all the Informix manuals and have purchased SE and > ISQL. It's very confusing as the manuals have varying versions on them... > 4, 6 and 7.X. As well they have information on ESQL which I assume I > don't have, having purchased SE and ISQL only. There are separate version numbers for the various Informix products, one for SE, one for SQL, one for OnLine, etc. Some of the manuals were updated and others were not for each new release. I write the version number of the product to which the manual applies on the spine of the manual. (We are running OnLine v4, 5, and 7!) > My question is: are there the standard relational operators available in > these products? Specifically I need UNION and JOIN, but I can't see > reference to them at all. I found multiple references to each of these under "Union" and "Join" in the indexs of the following manuals: SQL Tutorial SQL Reference SQL Syntax Guide 4GL Reference Manual before I got tired of looking! I would say RTFM but you must know R the FM first. :) > Thanks to everyone who helped on the PROMPT query..... > > --Kate __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|