Hello Experts, I am looking for someone who can help me with the below SQL script. I am looking to join the PaymentKey with that of a YearMonth in a different table as seen below, tried doing it in QV but gives me Memory Timed out error message, Can anyone suggest a best solution or help me with the below?
Consecutive_Amounts:
LOAD
Amount,
PaymentKey,
YearMonth;
SQL SELECT Amount,
PaymentKey,
YearMonth
FROM "AOF_DataMart".Reporting.vLastFctPayment
Where PortfolioKey = $(vPortfoliokey)
(SELECT PaymentKey,
YearMonth
FROM "AOF_DataMart".Reporting.LoanByYearMonth) Outer Join PaymentKey on PaymentKey
Order By YearMonth;
Thanks in Advance,
Mady