This simple query is giving me fits. Says, “Incorrect syntax near ‘POHeader’.”
If I change the calculated field to Sum instead of count I get no errors. What I want is the number of POs for each PartNum
select
[PODetail].[PartNum] as [PODetail_PartNum],
[POHeader].[EntryPerson] as [POHeader_EntryPerson],
(count( POHeader.PONum )) as [Calculated_Count]
from Erp.POHeader as POHeader
inner join Erp.PODetail as PODetail on
POHeader.Company = PODetail.Company
and POHeader.PONum = PODetail.PONUM
where POHeader.OrderDate >= ‘01/01/2017’ and POHeader.EntryPerson = ‘RichC’
group by [PODetail].[PartNum],
[POHeader].[EntryPerson]
order by PODetail.PartNum