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