SELECT
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
UNOIN
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
UNOIN
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM
服务器提示:
服务器: 消息 156,级别 15,状态 1,行 8
在关键字 'select' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 10
第 10 行: ')' 附近有语法错误。
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
UNOIN
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
UNOIN
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM
服务器提示:
服务器: 消息 156,级别 15,状态 1,行 8
在关键字 'select' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 10
第 10 行: ')' 附近有语法错误。
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
UNION
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
UNION
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
union
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
union
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
union
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
union
SELECT CPHM AS BM,CPHM AS MC FROM T_050
) AS B
ON A.BM=B.BM
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
UNION ALL
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
UNION ALL
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM
A.RQ,A.JE,A.BM,B.MC
FROM T_0713 A
LEFT JOIN
(
SELECT GYSBM AS BM,GSMC AS MC FROM T_0602
UNION
SELECT KHBM AS BM,KHMC AS MC FROM T_0501
UNION
SELECT CPHM AS BM,CPHM AS MC FROM T_050) AS B
ON A.BM=B.BM