grid sql
SELECT A1.C_UPLOAD_SYSTEMXLS_DETID, A1.NRID, A1.DESCRIPTION, A1.PRICE FROM
C_UPLOAD_SYSTEMXLS_DET A1
LEFT OUTER JOIN C_UPLOAD_SYSTEMXLS A2 ON (A1.C_UPLOAD_SYSTEMXLSID=A2.C_UPLOAD_SYSTEMXLSID)
LEFT OUTER JOIN C_CURRENCY A5 ON (A2.CURRENCY=A5.C_CURRENCYID)
LEFT OUTER JOIN C_LANGUAGE A4 ON (A2.LANG=A4.C_LANGUAGEID)
LEFT OUTER JOIN C_PRICELIST A3 ON (A2.C_PRICELISTID=A3.C_PRICELISTID)
WHERE (A3.C_PRICELISTID='QQF8AA0006BE') AND (A4.LANGDESCRIPTION='ENGLISH') AND (A5.CURRENCYNAME='GBP') AND (A2.DESCTYPE='short')
---
modified sql
SELECT T1.C_UPLOAD_SYSTEMXLS_DETID,t1.NRID,t1.[DESCRIPTION],T1.Price
FROM
(
--------------------------------------------------------------------------------------------------------------------
SELECT T2.C_UPLOAD_SYSTEMXLS_DETID,t1.pos ,t1.C_PRICELISTID,t1.NRID,t1.[DESCRIPTION],t1.DescType,T2.price,T1.Lang,T2.currency
FROM
( SELECT T2.C_UPLOAD_SYSTEMXLS_DETID,T1.C_PRICELISTID,T1.DescType,T1.Lang,T1.currency,T2.NRID,T2.[DESCRIPTION],T2.PRICE,T2.POS
FROM sysdba.C_UPLOAD_SYSTEMXLS T1
LEFT OUTER JOIN sysdba.C_UPLOAD_SYSTEMXLS_DET T2 ON T1.C_UPLOAD_SYSTEMXLSID = T2.C_UPLOAD_SYSTEMXLSID
)T1
INNER JOIN
( SELECT T2.C_UPLOAD_SYSTEMXLS_DETID,T1.C_PRICELISTID,T1.DescType,T1.Lang,T1.currency,T2.NRID,T2.[DESCRIPTION],T2.PRICE,T2.POS
FROM sysdba.C_UPLOAD_SYSTEMXLS T1
LEFT OUTER JOIN sysdba.C_UPLOAD_SYSTEMXLS_DET T2 ON T1.C_UPLOAD_SYSTEMXLSID = T2.C_UPLOAD_SYSTEMXLSID
)
T2 ON t1.nrid = t2.nrid
WHERE T1.C_PricelistID = 'QQF8AA0006BE' and t1.descType = 'short' and T2.C_PricelistID = 'QQF8AA0006BE' and t2.descType = 'short'
--------------------------------------------------------------------------------------------------------------------
)T1
LEFT JOIN sysdba.c_language T2 ON T1.lang = T2.c_languageid
LEFT JOIN sysdba.c_currency T3 ON T1.currency = T3.c_currencyid
WHERE
t2.langdescription = 'English' and t3.currencyname = 'usd'
it show
An error occurred execution active form script
invalid column name 'C_UPLOAD_SYSTEMXLSID'
help me |