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.
key start stop
1: 2 3
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??