Groups

    sql problem solving help needed

    I have to join 3 tables with sql code.

    If you can help can I pm you the code. I managed to get join 2 table not sure if it correct. Now I am struggling to understand how to do 3. I have test on this area tomorrow so I rather know how to do this process. Only started this recently

    8 Comments

    try sqlzoo.net that will help with sql needs..

    Send the code and I'll see if I can help

    send it over

    Suggestion sent by PM

    give someone sql code and he will run it over and over again.. give someone the means to write code and they can mine that data to hearts content..

    Happy to help if its not been resolved

    Something like this:

    SELECT s.studentname
    , s.studentid
    , s.studentdesc
    , h.hallname
    FROM students s
    INNER JOIN hallprefs hp
    on s.studentid = hp.studentid
    INNER JOIN halls h
    on hp.hallid = h.hallid
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Battery drain on iOS 1155
      2. Breath of the Wild Replacement Cover?11
      3. breakfree holiday passwords67
      4. How much would I get for iPhone 6S 64gb rose gold unlocked like new conditi…45

      See more discussions