--search select b1.* , b2.sex,b2.id , b2.addrss from b1 , b2 where b1.aname = b2.aname--create new table select b1.* , b2.sex,b2.id , b2.addrss into C from b1 , b2 where b1.aname = b2.aname select * from c
select a.*,b.* into c from b1 a,b2 b where a.aname = b.aname
select isnull(a.aname,b.aname)name, a.password, b.sex, b.id, b.address from b1 a full join b2 b on a.aname=b.aname
select b1.* , b2.sex,b2.id , b2.addrss from b1 , b2 where b1.aname = b2.aname--create new table
select b1.* , b2.sex,b2.id , b2.addrss into C from b1 , b2 where b1.aname = b2.aname
select * from c
into c
from b1 a,b2 b
where a.aname = b.aname