Inner Join Challenge

  • Thread starter Thread starter kremilk
  • Start date Start date
K

kremilk

Guest
Can anyone point out what am doing wrong with this inner join command.

SELECT SUM(CAST(chartsofaccountsTransactions.amountincome AS decimal(18, 2))) AS totalamount, clientsTransactions.accounttype, clientsTransactions.accountfund, clientsTransactions.accountdescription,
clientsTransactions.accountcategory, clientsTransactions.amountincome, clientsTransactions.amountexpenses, clientsTransactions.transactionid, clientsTransactions.transactiondate, clientsTransactions.receivefrom,
clientsTransactions.receiverpayee, clientsTransactions.transactionkind, clientsTransactions.accountname
FROM clientsTransactions INNER JOIN
chartsofaccountsTransactions ON clientsTransactions.receivefrom = chartsofaccountsTransactions.receivefrom AND clientsTransactions.transactiondate = chartsofaccountsTransactions.transactiondate
GROUP BY clientsTransactions.accountname


What do you think should be the right way for doing this?

Continue reading...
 
Back
Top