help me: How show to table data after other 1

[mnavahan]

Hi ALL

i must show below data of two table ..


Table 1 have this column : id, Comment , price, color
for ex. have this data : 1 wood 100 red
2 glass 200 brown

...

and
Table 2 have this column : id, price, Salenumber , color
1 300 5 red
2 500 7 blue

the up table must show in :


id, Comment , price, Salenumber ,color
1 wood 100 red
2 glass 200 brown
1 300 5 red
2 500 7 blue



note the field "Comment" in table1 no absent in table2
and field "Salenumber" in table2 no absent in table1

can any way write view to this up job ?
if no have any other way to do ?

THX of Helper

 

[PHV]

Have you tried to play with UNION ?

Hope This Help
PH.

 

[rrrkrishnan]

Try this.

select id, Comment , price, null as Salenumber ,color
from tbl1
union
select id, null as Comment , price, Salenumber ,color
from tbl2

 

[mnavahan]

THX nice