I have a series of select statements that are unioned togther. 1 of them I would like to be able to sort in addition to the sorting of the whole final table. I get a syntax error that prevent me from doing this. Can anyone provide some insight or mods to the example code? thx
where x = 1
where x = 2
order by b)
order by c
So in this example, the second select statement would be ordered by b, then the whole results would be ordered by c.
But alas - syntax error prevents this.
thx for any comments.