>>>That is why SET ENGINEBEHAVIOR 90 was presente, to make VFP queries more ANSI compatible.
>>>

>>>SELECT partmast.partnum,
>>>	partmast.title,
>>>	partmast.description,
>>>	NVL(partstats.emplviews+partstats.intviews,0000000) as Total_Views,
>>>	invitems.Cnt as sales_count 
>>>FROM partmast 
>>>	LEFT JOIN partstats ON partmast.partnum=partstats.partnum 
>>>	LEFT JOIN (SELECT partnum, COUNT(invitems.invnum) AS Cnt
>>>                          FROM invitems where PartNum = '12345'
>>>                   GROUP BY partnum) invitems ON partmast.partnum=invitems.partnum
>>>WHERE partmast.partnum='12345' 
>>>ORDER BY partnum
>>>

>>>
>>>

BTW, we may want to add PartNum = '12345' condition into the derived table as well - see the change above.