查询明细记录表相同父ID的记录ID，怎么简化？半天没写出来
SELECT BatchDetail_ID
FROM BatchDetail
WHERE BatchDetail_FaID IN
(SELECT BatchDetail_FaID
FROM BatchDetail
WHERE BatchDetail_Operator = '17 ')
怎么自关联简化一下？
[解决办法]
SELECT BatchDetail_ID
FROM BatchDetail as A,BatchDetail as B
WHERE A.BatchDetail_FaID=B.BatchDetail_FaID and A.BatchDetail_Operator = '17 '
这样行不？
[解决办法]
SELECT BatchDetail_ID
FROM BatchDetail
WHERE exists (SELECT BatchDetail_FaID
FROM BatchDetail
WHERE BatchDetail_Operator = '17 ')
[解决办法]
SELECT BatchDetail_ID
FROM BatchDetail b
WHERE EXISTS(SELECT * FROM BatchDetail
WHERE BatchDetail_FaID = b.BatchDetail_FaID AND
BatchDetail_Operator = '17 ')
[解决办法]
select BatchDetail_ID FROM BatchDetail WHERE BatchDetail_Operator = '17 '和你的语句没啥区别啊。
[解决办法]
SELECT DISTINCT A.BatchDetail_Id
FROM BatchDetail A INNER JOIN
(SELECT batchdetail_faId AS faid
FROM batchdetail
WHERE batchdetail_operator = '17 ') b ON A.BatchDetail_FaId = b.faid
[解决办法]
SELECT BatchDetail_FaID,BatchDetail_ID
FROM BatchDetail
WHERE BatchDetail_Operator = '17 ' GROUP BY BatchDetail_FaID,BatchDetail_ID
[解决办法]
是啊
select BatchDetail_ID FROM BatchDetail WHERE BatchDetail_Operator = '17 '
不和你上面的一样么？
