Mysql query mistake on inner join tables [closed]





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







1















enter image description here



Hi, I have two tables goods and delivery, I try to get from table delivery sum of field gived_amout grouping by table goods field name. But also in the query, I need field price, but I have an error on field price 



SELECT sum(I.gived_amount), P.name, P.price

FROM delivery I

INNER JOIN goods P ON P.id_g=I.id_g

GROUP BY P.name





mysql







share|improve this question















closed as off-topic by Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449 Nov 25 '18 at 11:35


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449

If this question can be reworded to fit the rules in the help center, please edit the question.

















  • And what is the error ? (the most important thing in your question !)

    – NoDataFound
    Nov 25 '18 at 10:56











  • Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

    – Chowkidar Madhur Bhaiya
    Nov 25 '18 at 11:00













  • mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

    – Jurijs Visockis
    Nov 25 '18 at 11:05













  • Maybe delete this question then

    – Joakim Danielson
    Nov 25 '18 at 11:06











  • sorry I found the mistake :-)

    – Jurijs Visockis
    Nov 25 '18 at 11:11




















1















enter image description here



Hi, I have two tables goods and delivery, I try to get from table delivery sum of field gived_amout grouping by table goods field name. But also in the query, I need field price, but I have an error on field price 



SELECT sum(I.gived_amount), P.name, P.price

FROM delivery I

INNER JOIN goods P ON P.id_g=I.id_g

GROUP BY P.name





mysql







share|improve this question















closed as off-topic by Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449 Nov 25 '18 at 11:35


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449

If this question can be reworded to fit the rules in the help center, please edit the question.

















  • And what is the error ? (the most important thing in your question !)

    – NoDataFound
    Nov 25 '18 at 10:56











  • Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

    – Chowkidar Madhur Bhaiya
    Nov 25 '18 at 11:00













  • mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

    – Jurijs Visockis
    Nov 25 '18 at 11:05













  • Maybe delete this question then

    – Joakim Danielson
    Nov 25 '18 at 11:06











  • sorry I found the mistake :-)

    – Jurijs Visockis
    Nov 25 '18 at 11:11
















1












1








1








enter image description here



Hi, I have two tables goods and delivery, I try to get from table delivery sum of field gived_amout grouping by table goods field name. But also in the query, I need field price, but I have an error on field price 



SELECT sum(I.gived_amount), P.name, P.price

FROM delivery I

INNER JOIN goods P ON P.id_g=I.id_g

GROUP BY P.name





mysql







share|improve this question
















enter image description here



Hi, I have two tables goods and delivery, I try to get from table delivery sum of field gived_amout grouping by table goods field name. But also in the query, I need field price, but I have an error on field price 



SELECT sum(I.gived_amount), P.name, P.price

FROM delivery I

INNER JOIN goods P ON P.id_g=I.id_g

GROUP BY P.name





mysql




mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 25 '18 at 19:27









Valerian Pereira

5251513




5251513










asked Nov 25 '18 at 10:54









Jurijs VisockisJurijs Visockis

66127




66127




closed as off-topic by Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449 Nov 25 '18 at 11:35


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449

If this question can be reworded to fit the rules in the help center, please edit the question.







closed as off-topic by Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449 Nov 25 '18 at 11:35


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Zoe, Temani Afif, Joakim Danielson, D-Shih, greg-449

If this question can be reworded to fit the rules in the help center, please edit the question.













  • And what is the error ? (the most important thing in your question !)

    – NoDataFound
    Nov 25 '18 at 10:56











  • Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

    – Chowkidar Madhur Bhaiya
    Nov 25 '18 at 11:00













  • mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

    – Jurijs Visockis
    Nov 25 '18 at 11:05













  • Maybe delete this question then

    – Joakim Danielson
    Nov 25 '18 at 11:06











  • sorry I found the mistake :-)

    – Jurijs Visockis
    Nov 25 '18 at 11:11





















  • And what is the error ? (the most important thing in your question !)

    – NoDataFound
    Nov 25 '18 at 10:56











  • Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

    – Chowkidar Madhur Bhaiya
    Nov 25 '18 at 11:00













  • mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

    – Jurijs Visockis
    Nov 25 '18 at 11:05













  • Maybe delete this question then

    – Joakim Danielson
    Nov 25 '18 at 11:06











  • sorry I found the mistake :-)

    – Jurijs Visockis
    Nov 25 '18 at 11:11



















And what is the error ? (the most important thing in your question !)

– NoDataFound
Nov 25 '18 at 10:56





And what is the error ? (the most important thing in your question !)

– NoDataFound
Nov 25 '18 at 10:56













Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

– Chowkidar Madhur Bhaiya
Nov 25 '18 at 11:00







Also, your GROUP BY usage is not valid. Do check this answer: stackoverflow.com/a/34115425/2469308

– Chowkidar Madhur Bhaiya
Nov 25 '18 at 11:00















mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

– Jurijs Visockis
Nov 25 '18 at 11:05







mistake is following SELECT list is not in GROUP BY clause and contains nonaggregated column 'P.price'

– Jurijs Visockis
Nov 25 '18 at 11:05















Maybe delete this question then

– Joakim Danielson
Nov 25 '18 at 11:06





Maybe delete this question then

– Joakim Danielson
Nov 25 '18 at 11:06













sorry I found the mistake :-)

– Jurijs Visockis
Nov 25 '18 at 11:11







sorry I found the mistake :-)

– Jurijs Visockis
Nov 25 '18 at 11:11














1 Answer
1






active

oldest

votes


















0














You should use GROUP BY P.name, P.price in order for the sql query to be syntactically correct.



According to sql you should put into the GROUP BY clause all non grouping columns (P.name and P.price in your case).






share|improve this answer
































    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    You should use GROUP BY P.name, P.price in order for the sql query to be syntactically correct.



    According to sql you should put into the GROUP BY clause all non grouping columns (P.name and P.price in your case).






    share|improve this answer






























      0














      You should use GROUP BY P.name, P.price in order for the sql query to be syntactically correct.



      According to sql you should put into the GROUP BY clause all non grouping columns (P.name and P.price in your case).






      share|improve this answer




























        0












        0








        0







        You should use GROUP BY P.name, P.price in order for the sql query to be syntactically correct.



        According to sql you should put into the GROUP BY clause all non grouping columns (P.name and P.price in your case).






        share|improve this answer















        You should use GROUP BY P.name, P.price in order for the sql query to be syntactically correct.



        According to sql you should put into the GROUP BY clause all non grouping columns (P.name and P.price in your case).







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Nov 25 '18 at 11:51

























        answered Nov 25 '18 at 11:16









        adrhcadrhc

        515414




        515414

















            -

            這個網誌中的熱門文章

            Xamarin.form Move up view when keyboard appear

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I'm trying to build a Chat app UI, the idea of the Layout was pretty simple: When the input bar is focused, keyboard show up and "push" up the chat bar, as it's a grid, the ListView will resize to fit the screen: I update the input bar's margin to "push" it up: NSValue result = (NSValue)args.Notification.UserInfo.ObjectForKey(new NSString(UIKeyboard.FrameEndUserInfoKey)); CGSize keyboardSize = result.RectangleFValue.Size; if (Element != null){ Element.Margin = new Thickness(0, 0, 0,keyboardSize.Height); //push the entry up to keyboard height when keyboard is activated } And this is ...
            閱讀完整內容

            Post-Redirect-Get with Spring WebFlux and Thymeleaf

            圖片
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 Can someone explain to me how to implement the post-redirect-get pattern in Spring WebFlux and Thymeleaf? What subscribes on the database save method? @GetMapping("/register") public String showRegisterForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping public String processRegisterForm(@Valid User user, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "register"; } else { userRepository.save(user); //what subscribes on this? //how to redirect on e.g. "/login"? ...
            閱讀完整內容

            Anylogic : not able to use stopDelay()

            圖片
            -2 I am building a railway station model. I want a train to depart when I click a button. I want to call stopDelay() for that but I am not sure how to do that and from which place. anylogic share | improve this question asked Nov 23 '18 at 10:12 Anupam Singh Anupam Singh 1 Hi Anupam, welcome to SOF. Please check how to ask good questions, see link below. Your question is...
            閱讀完整內容