Hi, I've got to join 3 tables with aliases
I'm having trouble with the t5 onwards. The closing bracket should be the matching on to the select after FIRST FROM.. The t6 closing bracket should be the opening first select.
(SELECT * FROM (SELECT T1.company, ISNULL(T2.company_a,T1.company) as company_lookup, ISNULL(T3.user_count,0) as user_count, ISNULL(T4.user_count,0) as user_count_lookup FROM (SELECT * FROM accounts) As T1 LEFT JOIN (SELECT * FROM account_link) As T2 ON T1.company = T2.company_b LEFT JOIN (SELECT company, count(*) as user_count FROM client WHERE user_type = 2 and user_status != 7 group by company) As T3 on T1.company = T3.company LEFT JOIN (SELECT company, count(*) as user_count FROM client WHERE user_type = 2 and user_status != 7 group by company) As T4 on T2.company_a = t4.company)) As T5 LEFT JOIN (SELECT * FROM accounts)) As T6 ON T5.company = T6.company WHERE (T5.user_count_lookup + T5.user_count) = 0