我想在限制100之内选择NULL值.左联接应使输出限制为100,并且在其中我要计算所有NULL值.我的子查询似乎无法正常工作.有什么想法我做错了吗？提前致谢！

我用SUM()尝试了一些东西,但是那也行不通

@H_404_8@SELECT SUM(echonest.id IS NULL) FROM (SELECT *
FROM tracks,echonest
left JOIN echonest ON tracks.id = echonest.id 
LIMIT 100)

SELECT *
FROM tracks AS t
LEFT JOIN echonest AS e ON t.id = e.id
LIMIT 100 IN 
(SELECT COUNT(e.id)
FROM e
WHERE e.id IS NULL)

预期的输出应计入LIMIT 100以内的所有NULL值.