Add column to select statement (ie value from another table)

[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

Edited September 28, 2020 by Michelle
trying to notify myself if reply, cant find it

[Michelle]

Not to worry thank you, I found the answer:

 

SELECT AutoNumber,DDAte,Amount*(-1) as Amount, (select CoName from LedgerParameters) as Company 
FROM LedgerTransactions LT 
WHERE DDATE >= DATEFROMPARTS(2019,01,01) 
AND LT.AccNumber IN 
 (select distinct AccNumber FROM LedgerMaster) 
ORDER BY ddate DESC