sql problem solving help needed - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

sql problem solving help needed

£0.00 @
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 th… Read More
daisys77 Avatar
2m, 6d agoPosted 2 months, 6 days ago
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
daisys77 Avatar
2m, 6d agoPosted 2 months, 6 days ago
Options

All Responses

(8) Jump to unreadPost an answer
Responses/page:
#1
try sqlzoo.net that will help with sql needs..
#2
Send the code and I'll see if I can help
#3
send it over
#4
https://www.w3schools.com/sql/sql_join.asp

use the same approach to add a third table.
#5
Suggestion sent by PM
#6
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..
#7
Happy to help if its not been resolved
#8
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 an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!