Question

怎样将结构完全一样的表和视图做成一个新的视图，SQL语句

CREATE VIEW inv_stock_detail_vvv AS SELECT *
FROM (SELECT item_code, warehouse,
stock_date
FROM dbo.inv_stock_detail_vv
UNION ALL
SELECT item_code, warehouse,
stock_date
FROM dbo.inv_h_stock_detail)
使用这段代码系统报错
问题已解决，需要对虚拟表命名
CREATE VIEW inv_stock_detail_vvv AS SELECT *
FROM (SELECT item_code, warehouse,
stock_date
FROM dbo.inv_stock_detail_vv
UNION ALL
SELECT item_code, warehouse,
stock_date
FROM dbo.inv_h_stock_detail) as a
这样就可以了

Answer 1

create view v_test
as
select t1.id,t2.name as atypename,t3.name as btypename
from 表1 t1 left join 表2 t2 on t1.atypeid=t2.typeid
left join 表2 t3 on t1.btypeid=t3.typeid

Answer 2

具体点报什么错呢，估计是你两种表有不一致的类型导致的