tag:blogger.com,1999:blog-2807403883562053852.post6581388523179912121..comments2024-03-27T08:40:31.785-06:00Comments on Clayton Cramer.: Informix SQL Bug?Clayton Cramerhttp://www.blogger.com/profile/03258083387204776812noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2807403883562053852.post-39631578586345821162014-01-23T14:45:09.287-07:002014-01-23T14:45:09.287-07:00Re: your final sentence:
The INTO and ORDER BY cl...Re: your final sentence:<br /><br />The INTO and ORDER BY clauses apply to the entire statement SELECT ... UNION SELECT ...<br /><br />The INTO clause has to go somewhere, and the choice of first SELECT vs. second SELECT (third, etc) is arbitrary, yes, but it makes a sort of sense.<br /><br />As for the ORDER BY clause, think of it like this:<br /><br />(<br />SELECT ...<br />UNION<br />SELECT ...<br />) ORDER BY ...<br /><br />N.B. I have only 11 months of Informix experience, but nearly 20 years of Oracle experience.Hal Dustonhttps://www.blogger.com/profile/03579515713751458192noreply@blogger.com