Topics started by tcboutte

1 Topic

T
Do Gooder
tcboutteDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Reports SQL - Multiple Left Join Issue

Does anyone know why the following SQL doesn't work in IFS? I only seems to work without the last LEFT JOIN and the associated column that I want to bring in at the bottom of my SELECT statement. I’ve verified the column names exist, but unfortunately the errors in IFS point me nowhere. Thanks! WITH FilteredAccount AS (    SELECT *     FROM ACCOUNT     WHERE Company = '4400')SELECT    GEN_LED_VOUCHER_ROW_QRY.Company,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Type,    GEN_LED_VOUCHER_ROW_QRY.Voucher_No,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Year,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Period,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Date,    GEN_LED_VOUCHER_ROW_QRY.Year_Period,    GEN_LED_VOUCHER_ROW_QRY.Account,    GEN_LED_VOUCHER_ROW_QRY.Account_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_B,    GEN_LED_VOUCHER_ROW_QRY.Code_B_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_C,    GEN_LED_VOUCHER_ROW_QRY.Code_C_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_D,    GEN_LED_VOUCHER_ROW_QRY.Code_D_Desc,    GEN_LED_VOUCHER_ROW_QRY

6
T
Do Gooder
8 months ago

Badges

Show all badges
Terms & ConditionsCookie settings