Share
ReportHi,
Can anyone help in converting this to fetchxml?
select DATEPART(year, op.CreatedOn) AS [Year], DATEPART(month, op.CreatedOn) AS [Month], p2.ProductNumber, SUM(op.ExtendedAmount) AS [Amount]
from dbo.OpportunityProduct op
inner join dbo.Product p1 on (op.ProductId = p1.ProductId)
left outer join dbo.Product P2 on (p1.ParentProductId = p2.ProductId)
group by DATEPART(year, op.CreatedOn), DATEPART(month, op.CreatedOn), p2.ProductNumber
http://www.sql2fetchxml.com/ says: Secondary conditions of a JOIN clause must follow the first ON condition using an AND operator.
If I
....
inner join dbo.Product p1 on (op.ProductId = p1.ProductId) AND
left outer join dbo.Product P2 on (p1.ParentProductId = p2.ProductId)
.....
I get: Error occurred when parsing the SQL script: Unsupported statement type: outer
Any ideas would be most appreciated.
Regards, Steve
All responses (
Answers (
292,494
