34,590
社区成员
发帖
与我相关
我的任务
分享
select * from Table1 where ID in (
select ID from Table1 where 发货 ='未发完')
SELECT * FROM TABLE A
WHERE EXISTS
(SELECT 1 FROM TABLE WHERE ID=A.ID AND 发货='未发完')
SELECT * FROM TABLE
WHERE ID IN
(SELECT ID FROM TABLE WHERE 发货='未发完')
selecct * from table where 发货 like‘未发完’
SELECT * FROM((
SELECT 姓名, 数量, 未发, 备注 FROM [IN]
RIGHT JOIN
(SELECT INID FROM[IN] WHERE LEFT([INID], 2) = 'BH' AND 未发 <> '已发完' GROUP BY INID) A ON[A].INID = [IN].INID
ORDER BY 姓名) SSS
LEFT JOIN
(SELECT 最小日期, B.姓名, 地址 FROM (SELECT MIN(A.日期) AS 最小日期, 姓名 FROM (SELECT 姓名, 日期 FROM [IN]
RIGHT JOIN
(SELECT INID FROM[IN] WHERE LEFT([INID], 2) = 'BH' AND 未发 <> '已发完' GROUP BY INID) A ON[A].INID = [IN].INID) A GROUP BY 姓名) B
LEFT JOIN [客户] ON[B].姓名 =[客户].姓名) SS
ON SSS.姓名 = SS.姓名)
ORDER BY 最小日期,SS.姓名
SELECT * FROM ((SELECT 姓名, 数量, 未发, 备注 FROM[IN] RIGHT JOIN(SELECT INID FROM[IN] WHERE LEFT([INID], 2) = 'BH' AND 未发 <> '已发完' GROUP BY INID) A ON[A].INID = [IN].INID ORDER BY 姓名) SSS LEFT JOIN(SELECT 最小日期, B.姓名, 地址 FROM (SELECT MIN(A.日期) AS 最小日期, 姓名 FROM
(SELECT 姓名, 日期 FROM [IN] RIGHT JOIN(SELECT INID FROM[IN] WHERE LEFT([INID], 2) = 'BH' AND 未发 <> '已发完' GROUP BY INID) A ON[A].INID = [IN].INID) A GROUP BY 姓名) B lEFT JOIN[客户] ON[B].姓名 =[客户].姓名) SS ON SSS.姓名 = SS.姓名) ORDER BY 最小日期,SS.姓名