Nothing like that i have used what u said like only..creating temporary table and using joins only..Thanks for ur help...I just want to know whether its possible or not..But i...

No i don't want to use joins at all..I just want to know whether its possible to combine?

I'm not getting anything from that..can u explain it?

I'm not getting anything from that..can u explain it?

create table t1(marks int)

create table t2(comments varchar(10))

insert into t1 values(100)

insert into t1 values(200)

insert into t2 values('d')

insert into t2 values('i')

I have created two tables t1 and t2.i have different two columns...