有个问题，没有头绪了，求大神指点

[liusm001]

customer order
ID ID customerID

有这么俩个表，想读出Customer在Order里最少或者没有的那个ID。

基础不太好，思路有点别扭，求指点

[娃都会打酱油了]

SELECT TOP 1
        cid
FROM    ( SELECT    c.ID AS CID ,
                    o.ID AS OID ,
                    COUNT(0) AS 'TCount'
          FROM      [customer] c
                    LEFT JOIN [order] o ON c.ID = o.ID
          GROUP BY  c.ID ,
                    o.ID
        ) t
ORDER BY TCount

这样？

[liusm001]

T-SQL我都懂， linq能写出来么这种？

[liusm001]

引用 1 楼 starfd 的回复:

SELECT TOP 1
        cid
FROM    ( SELECT    c.ID AS CID ,
                    o.ID AS OID ,
                    COUNT(0) AS 'TCount'
          FROM      [customer] c
                    LEFT JOIN [order] o ON c.ID = o.ID
          GROUP BY  c.ID ,
                    o.ID
        ) t
ORDER BY TCount

这样？

T-SQL我读懂了， linq能写出这种么？ 我用foreach可以达到效果但是觉得那么写太麻烦