Question

SQL查询结果合并到一个表

select keycode,房屋坐落,产权面积,所有权证号,所有权人,Convert(varchar,收件日期,23) from filesin where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%')
select keycode,rvalue,Convert(varchar,gddate,23) from zlink where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%')

select keycode,tel from zperson where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%')
将这3个查询结果合并到一个表（按keycode字段）里，高手们帮帮忙吧

Answer 1

Select X.*,y.*,z.* From
(select keycode,房屋坐落,产权面积,所有权证号,所有权人,Convert(varchar,收件日期,23) from filesin where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%')) X,
(select keycode,rvalue,Convert(varchar,gddate,23) from zlink where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%')) Y,
(select keycode,tel from zperson where keycode in (SELECT keycode FROM zlink WHERE Convert(varchar,gddate,120)between '20130701'and '20130731'and regtype like '%商品%') Z
Where X.KeyCode = Y.KeyCode and Y.KeyCode = Z.KeyCode

以上是字段全累加。如不需要可以在第一句中一一标注如：select x.KeyCode,y.rvalue,z.tel From x,y,z ....................................

Answer 2

23将这3个查询结果合并到一个表（按keycode字段）里，高手们帮帮忙吧