JOIN/DB Question

[Anon]

After 2 hours of work, I'm resorting to support forums =). Sorry for the simplicity of the question.

I have two tables, and would like to return results from both of them. I have one table called "current_options" with fields "id" (primary key), "location", and "description".
The other table is "travellocations" with fields "id" (primary key), and "name". The 'location' field in the first table contains 'id' values from the second.

I would like to return all of the descriptions and names (the value in the second table, not the number in the first). Thanks in advance for any help.

Luke

[Anon]

I'm can't tell exactly what you want.
If you are trying to return the description from the current_options table and the name from the travelloactions table where the location number matches the id in the travellocations id then this will work:

SELECT C.description, T.name FROM current_options as C, travellocations as T WHERE C.location=T.id

[siwis]

Haven't got your tables to work with but give this a go:

$c = "current_options";
$t = "travellocations";

$sql = "SELECT
$c.id.
$c.description,
$t.name,
FROM
$t
LEFT JOIN
$c
ON
$c.location = $t.id
GROUP BY
$t.name";