我的数据库视图中有两个表的关联,我想在加一张表,要加的表与Zd_Fw_Xm的字段相同,字段明相同,我也不大会叙述,大概就是将以下两句合在一起吧,请高手指点,我很菜,请写一下原代码。
SELECT dbo.Xs_Zy_Fw.Zy_Dj, dbo.Xs_Zy_Fw.Xm_Code, dbo.Zd_Fw_Xm.Xm_Name,
dbo.Zd_Fw_Xm.Xm_Dm
FROM dbo.Xs_Zy_Fw INNER JOIN
dbo.Zd_Fw_Xm ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Xm.Xm_Code
SELECT dbo.Xs_Zy_Fw.Zy_Dj, dbo.Xs_Zy_Fw.Xm_Code, dbo.Zd_Fw_Yp.Xm_Name,
dbo.Zd_Fw_Yp.Xm_Dm
FROM dbo.Xs_Zy_Fw INNER JOIN
dbo.Zd_Fw_Yp ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Yp.Xm_Code
SELECT dbo.Xs_Zy_Fw.Zy_Dj, dbo.Xs_Zy_Fw.Xm_Code, dbo.Zd_Fw_Xm.Xm_Name,
dbo.Zd_Fw_Xm.Xm_Dm
FROM dbo.Xs_Zy_Fw INNER JOIN
dbo.Zd_Fw_Xm ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Xm.Xm_Code
SELECT dbo.Xs_Zy_Fw.Zy_Dj, dbo.Xs_Zy_Fw.Xm_Code, dbo.Zd_Fw_Yp.Xm_Name,
dbo.Zd_Fw_Yp.Xm_Dm
FROM dbo.Xs_Zy_Fw INNER JOIN
dbo.Zd_Fw_Yp ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Yp.Xm_Code
dbo.Zd_Fw_Yp.Xm_Dm
FROM dbo.Xs_Zy_Fw INNER JOIN
dbo.Zd_Fw_Yp ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Yp.Xm_Code
INNER JOIN
dbo.Zd_Fw_Xm ON dbo.Xs_Zy_Fw.Xm_Code = dbo.Zd_Fw_Xm.Xm_Code
可用union