cross table mysql logic problem...

Hi, I have 2 tables, one containing jobs and the other locations.
the jobs have a start and stop location field using the keyid of the locations.

e.g.
job:
key  start stop
1:     2      3

location:
key  description
1:     test1
2:     test2
3:     test3

What i want is to return:
job id:1 start:test2 stop:test

Hope that makes sense, only need the query..

Can anyone help please??
ewan69Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
mahomeCommented:
You need to double join the location table:

select j.key, l1.description as start, l2.description as stop
from job j, location l1, location l2
where j.start = l1.key
and j.stop = l2.key

Open in new window

0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
ewan69Author Commented:
Hi mahome,

Thanks for the quick reply. Works thanks, spent a good couple of hours trying to work it out...

Thanks,

Ewan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.