Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Inner Join Challenge RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    you could ask here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql

    Regards, Guido

    Tuesday, May 21, 2019 7:26 AM