CREATE VIEW st_cggg AS (SELECT bt_id, bt_pid, bt_title, bt_fbtime, bw_name, bt_content,
bt_fj, bt_isfb
FROM bid_tonggao LEFT OUTER JOIN
bid_project ON
bid_project.bp_id = bid_tonggao.bt_pid LEFT OUTER JOIN
bid_way ON bid_project.bp_cfs = bid_way.bw_id
WHERE bt_isfb = '1'
UNION ALL
SELECT bp_id bt_id, bp_pid bt_pid, ('关于' + rtrim(bp_xmmc)
+ rtrim(bp_xmbh) + '采购公告') bt_title,
bp_cgggzrsshsj bt_fbtime, bp_cgfs bw_name,
bp_cgggcontent bt_content, bp_cgggfilepath bt_fj,
bp_isfb bt_isfb
FROM hzoa_new.dbo.bid_plan
WHERE charindex('cggg', bt_isfb) > 0) go帮忙看一下
bt_fj, bt_isfb
FROM bid_tonggao LEFT OUTER JOIN
bid_project ON
bid_project.bp_id = bid_tonggao.bt_pid LEFT OUTER JOIN
bid_way ON bid_project.bp_cfs = bid_way.bw_id
WHERE bt_isfb = '1'
UNION ALL
SELECT bp_id bt_id, bp_pid bt_pid, ('关于' + rtrim(bp_xmmc)
+ rtrim(bp_xmbh) + '采购公告') bt_title,
bp_cgggzrsshsj bt_fbtime, bp_cgfs bw_name,
bp_cgggcontent bt_content, bp_cgggfilepath bt_fj,
bp_isfb bt_isfb
FROM hzoa_new.dbo.bid_plan
WHERE charindex('cggg', bt_isfb) > 0) go帮忙看一下
SELECT bp_id ,bt_id, bp_pid bt_pid, ('关于' + rtrim(bp_xmmc)
这里少了一个逗号
SELECT bt_id, bt_pid, bt_title, bt_fbtime, bw_name, bt_content,
bt_fj, bt_isfb
FROM bid_tonggao LEFT OUTER JOIN
bid_project ON
bid_project.bp_id = bid_tonggao.bt_pid LEFT OUTER JOIN
bid_way ON bid_project.bp_cfs = bid_way.bw_id
WHERE bt_isfb = '1'
UNION ALL
SELECT bp_id bt_id, bp_pid bt_pid, ('关于' + rtrim(bp_xmmc)
+ rtrim(bp_xmbh) + '采购公告') bt_title,
bp_cgggzrsshsj bt_fbtime, bp_cgfs bw_name,
bp_cgggcontent bt_content, bp_cgggfilepath bt_fj,
bp_isfb bt_isfb
FROM hzoa_new.dbo.bid_plan
WHERE charindex('cggg', bt_isfb) > 0
(SELECT
bt_id,
bt_pid,
bt_title,
bt_fbtime,
bw_name,
bt_content,
bt_fj,
bt_isfb
FROM bid_tonggao
LEFT OUTER JOIN bid_project ON bid_project.bp_id = bid_tonggao.bt_pid
LEFT OUTER JOIN bid_way ON bid_project.bp_cfs = bid_way.bw_id
WHERE bt_isfb = '1'UNION ALLSELECT
bp_id bt_id,
bp_pid bt_pid,
('关于' + rtrim(bp_xmmc) + rtrim(bp_xmbh) + '采购公告') bt_title,
bp_cgggzrsshsj bt_fbtime,
bp_cgfs bw_name,
bp_cgggcontent bt_content,
bp_cgggfilepath bt_fj,
bp_isfb bt_isfb
FROM hzoa_new.dbo.bid_plan
WHERE charindex('cggg', bt_isfb) > 0)
go
可建立试图 查询设计器不支持 UNION SQL 构造。。