none
Inner Join Challenge RRS feed

  • Question

  • 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?

    Monday, May 13, 2019 5:11 AM

Answers

All replies

  • Hi kremilk,

    Welcome to the MSDN forum.

    Could you share us the project type and language you use to compiler? When did you encounter this error?

    What is version of OS and VS?

    We need more info to investigate it. Looking forward your reply.

    Best

    May


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, May 14, 2019 2:48 AM
  • Hi Kremilk,

    It seems that it was not the VS IDE issue, so I move it to the where is the forum for, and then other team members could redirect you to the correct forum. But if it is related to the SQL Server, you could select the SQL forum from the MSDN.

    Best Regards,

    Jack


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, May 21, 2019 7:08 AM
  • Tuesday, May 21, 2019 7:26 AM