-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Michelle
-
-
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
Add column to select statement (ie value from another table)
in SQL
Posted
Not to worry thank you, I found the answer: