SELECT partmast.partnum, partmast.title, partmast.description, NVL(partstats.emplviews+partstats.intviews,0000000) as Total_Views, COUNT(invitems.invnum) as sales_count FROM partmast LEFT OUTER JOIN partstats ON partmast.partnum=partstats.partnum LEFT OUTER JOIN invitems ON partmast.partnum=invitems.partnum WHERE partmast.partnum='12345' GROUP BY pk ORDER BY partnumHow can I do the equivalent in T-SQL? So far I have:
SELECT partmast.partnum, partmast.title, ISNULL(partstats.emplviews+partstats.intviews,0000000) as Total_Views, COUNT(invitems.invnum) as sales_count FROM partmast LEFT OUTER JOIN partstats ON partmast.partnum=partstats.partnum LEFT OUTER JOIN invitems ON partmast.partnum=invitems.partnum WHERE partmast.partnum='12345' GROUP BY partmast.partnum,partmast.title ORDER BY partnumBut it complains and wants me to include partstats.emplviews which may or may not exists... thus the ISNULL