help writing query

[michaelgr1]

Hello, I write a query (combine of 2 queries using UNION): query1 UNION query2 I want the result of query 2 (there is only one result in query2) will be placed in the last row of the results of the big query. I mean the results of query1 will be in the first rows and the result of the query2 will be in the last row. How can i do it?

[Blue_Boy]

Example select * from table1 union select * from table2

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[michaelgr1]

OK, I know that. But the problem is that the results are mixed. I want the results of the second query will be the last (in the last rows of the result big table)

[Ashfield]

The easiest way I know of is to introduce a sorting column

select '1' as seq,* from table1
union
select '2' as seq from table2
order by seq

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[David Mujica]

Remember that SQL unions are based on set theory, so if value A is from table 1 and value A is also from table 2 you would only get one value A is your result set. By introducing the sort indicator that "Ashfield" suggests, you would get 2 values of A. You would get 1,A and 2,A. I'm not sure if this would impact your algorithm, but I just wanted to make you aware of it. Cheers, David