SQL Query Not Working

Support Queries Astera Centerprise
1

I am unable to run the following SQL code. It does work on some competitor packages.

SELECT DISTINCT COR_CUSTOMER_CODE, SUM(DispatchedTotal) Value FROM

(

SELECT DISTINCT C.COR_PART_ONLY, C.COR_OUR_NUMBER, C.COR_OUR_NUMBER_N,

C.COR_CUSTOMER_CODE,

COR_QTY_ORDERED, COR_PRICE_PER, COR_QTY_ORDERED * COR_PRICE_PER OrderedTotal
,

COR_QTY_INVOICED * COR_PRICE_PER DispatchedTotal

FROM COR_TBL C

INNER JOIN

(

SELECT COR_PART_ONLY, COR_OUR_NUMBER, COR_OUR_NUMBER_N

FROM COR_TBL

WHERE COR_PART_ONLY IN (‘P412SETA’, ‘P412SETB’)

)P ON C.COR_OUR_NUMBER = P.COR_OUR_NUMBER

)AS C

GROUP BY COR_CUSTOMER_CODE

2

This issue is now fixed and is available in the newest build of Centerprise. I have emailed the build link. Please download and install; let me know if this has solved the issue and/or if you have any other questions or concerns.