Hi there,
Could anyone please help me to combine the below SQL statements such that the result is a 4 column table as shown in my screenshot?
/* entire table here */
SELECT AutoNumber, DDAte, Amount
FROM LedgerTransactions LT
WHERE DDATE >= DATEFROMPARTS(2019,01,01)
AND LT.AccNumber IN
(select distinct AccNumber FROM LedgerMaster)
ORDER BY ddate DESC
/* add CoName to above table as 4th column,
same value for every row */
select CoName from LedgerParameters
Thank you in advance,
Michelle