The SQL generated by Cognos 8 is often misunderstood. This document explains the SQL that results in common situations.
Note: The SQL examples shown in this document were edited for length and are used to highlight specific examples.
This document is available in English, French, German, and Japanese. To access it in a different language, go to installation location\cognos\c8\webcontent\documentation and open the folder for the language you want. Then open ug_best.pdf.