http://www.sqlteam.com/article/union-selecting-from-multiple-tables-in-one-statement
select col1 from tblA order by col2 desc
union
select col2 from tblB order by col2 desc
-It gives error.
Workaround is:
select col1 from tblA
union
select col2 from tblB order by col2 desc
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment