Question

SQL问题(在关键字 'SELECT' 附近有语法错误)

SELECT A.*,D.*
FROM BK_HEADER A WITH (NOLOCK)
LEFT JOIN
(
SELECT
C.BK_NO_ID,
SUM(CASE WHEN LEFT(C.CONTAINER_TYPE,1)='2' and C.CONTAINER_TYPE<>'20RF' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T20,
SUM(CASE WHEN C.CONTAINER_TYPE='20RF' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T20RF,
SUM(CASE WHEN LEFT(C.CONTAINER_TYPE,1)='4' AND C.CONTAINER_TYPE<>'40HC' AND C.CONTAINER_TYPE<>'40RH'AND C.CONTAINER_TYPE<>'40RF' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40,
SUM(CASE WHEN C.CONTAINER_TYPE='40HC' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40HC,
SUM(CASE WHEN C.CONTAINER_TYPE='40RH' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40RH,
SUM(CASE WHEN LEFT(CONTAINER_TYPE,1)='2' THEN ISNULL(C.QUANTITY,0) ELSE 2*ISNULL(C.QUANTITY,0) END) AS TEU
FROM BK_REQUEST_EQUIPMENTS C WITH (NOLOCK)
GROUP BY C.BK_NO_ID
)AS D
服务器: 消息 156，级别 15，状态 1，过程 IBConigneeList，行 8
在关键字 'SELECT' 附近有语法错误。
这是怎么回事
select A*,D*那边

Answer 1

left join必须加上ON字句指定连接条件
如果闭野乱A和D没有关联条件，那就这么写
SELECT A.*,D.*
FROM BK_HEADER A WITH (NOLOCK)
LEFT JOIN
(
SELECT
C.BK_NO_ID,
SUM(CASE WHEN LEFT(C.CONTAINER_TYPE,1)='2' and C.CONTAINER_TYPE<>'20RF' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T20,
SUM(CASE WHEN C.CONTAINER_TYPE='20RF'轿档 THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T20RF,
SUM(CASE WHEN LEFT(C.CONTAINER_TYPE,1)='4' AND C.CONTAINER_TYPE<>'40HC' AND C.CONTAINER_TYPE<>'40RH'AND C.CONTAINER_TYPE<>'40RF'脊码 THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40,
SUM(CASE WHEN C.CONTAINER_TYPE='40HC' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40HC,
SUM(CASE WHEN C.CONTAINER_TYPE='40RH' THEN ISNULL(C.QUANTITY,0) ELSE 0 END) AS T40RH,
SUM(CASE WHEN LEFT(CONTAINER_TYPE,1)='2' THEN ISNULL(C.QUANTITY,0) ELSE 2*ISNULL(C.QUANTITY,0) END) AS TEU
FROM BK_REQUEST_EQUIPMENTS C WITH (NOLOCK)
GROUP BY C.BK_NO_ID
)AS D
ON 1=1

Answer 2

这样可以绑亏亏定吗不能先答没把"select
ID
From
SQL
where
ID='100'"这部分数据读出来
DataSet/Table再绑定到Adodc1.RecordSource上吗？直接绑定我还没使用过可以咧VB语言貌似不销举神是这样写的吧建议
一步一个脚印别太急了！~~