Jump to content

Michelle

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by Michelle

  1. 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

    screenshot.png

×
×
  • Create New...