ewan69
asked on
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??
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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick reply. Works thanks, spent a good couple of hours trying to work it out...
Thanks,
Ewan