Jump to content

Michelle

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Michelle

  1. 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
  2. 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
×
×
  • Create New...