<div>
Hi mahome, <br />
<br />
Thanks for the quick reply. Works thanks, spent a good couple of hours trying to work it out...<br />
<br />
Thanks,<br />
<br />
Ewan
</div>


Hi mahome,

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

Thanks,

Ewan

<div>
<div class="content wysiwyg-content">
Hi, I have 2 tables, one containing jobs and the other locations.<br />
the jobs have a start and stop location field using the keyid of the locations.<br />
<br />
e.g.<br />
job:<br />
key &nbsp;start stop<br />
1: &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp;3<br />
<br />
location:<br />
key &nbsp;description<br />
1: &nbsp; &nbsp; test1<br />
2: &nbsp; &nbsp; test2<br />
3: &nbsp; &nbsp; test3<br />
<br />
What i want is to return:<br />
job id:1 start:test2 stop:test<br />
<br />
Hope that makes sense, only need the query..<br />
<br />
Can anyone help please??
</div>
</div>


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??

cross table mysql logic problem...

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.