(SELECT MAX(A.DAT)
FROM SALNO A
WHERE A.SAL_NO IN (SELECT B.SAL_NO
FROM SALNO01 B
WHERE B.PRD_NO = PRDNO01.PRD_NO AND
B.WHR = PRDNO01.WHR
)
) AS DAT1,
我只改一段給你試看看
(SELECT MAX(A.DAT)
FROM SALNO A
WHERE exists (SELECT B.SAL_NO
FROM SALNO01 B
WHERE B.PRD_NO = PRDNO01.PRD_NO AND
B.WHR = PRDNO01.WHR and
B.SAL_NO=A.SAL_NO
)
) AS DAT1,
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.115.193.210
推
09/05 23:16, , 1F
09/05 23:16, 1F
推
09/05 23:22, , 2F
09/05 23:22, 2F
討論串 (同標題文章)
完整討論串 (本文為第 3 之 3 篇)：