Solved - Re: [thelist] Oracle "in" question & owed tip

rudy r937 at interlog.com
Wed Nov 20 17:36:03 CST 2002


> Select foo from tables where fielda='value 1'
> ORDER BY 15, 16, 2, 13, 14
> Union
> Select foo from tables where fielda='value 2'
> ORDER BY 15, 16, 2, 13, 14
>
> is bad,

correct, a select can have only one order by

it's a common gotcha

the select in this case is a "fullselect" --    ( select union select )

the parts of a fullselect are more properly called subselects

there are other types of fullselect, like intersection and exception...

by the way, congrats on the oracle hints

that is way past beginner level


rudy




More information about the thelist mailing list