Hello all, Have a little problem with to make a sql-query as I want to have it... The problem is I need to check in 3 tables and count out and get it presentated per "n_id" like
n_id counted 01 5 02 10 03 2 My tables look as follows... In sub: id n_id In us: id email In sub_del: n_id id I have already a query that count it out totally. SELECT (SELECT count(sub_id) from sub) - (SELECT count(us.id) FROM us LEFT JOIN sub ON sub.id = us.id)+(SELECT count(*) FROM sub_del); But my problem is that I want to be able to get out the result per sub.n_id instaead. Please help! /Joppe -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
