How to merge two select statements results?

[dinhdai88]

Say I have two statements in a stored proc,

i.e.

select id, title, order from table 1

select id2, title2, order from table 2

I want to have a table returned with id, title, id2, title2, order






_______________________________
Vietnam holidays-Halong Violet Cruise-Mekong RV Indochine Cruise