mysql - joins - newbie question

[jeroom]

below you will find 3 tables, it's no big deal to put 3 queries, but i want just one query, i guess with joins... but i'm not good at that ;s
maybe some help from you guys? :o
tnx in advance

--> i want to replace the id_regie and id_land with the table 2 and 3 so it will show the values...

table 1

id_land | id_regie | id_land | name

1 | 9 | 8 | name1
2 | 5 | 4 | name2

table 2

id_land | land

1 | land1

2 | land2
...

table 3

id_regie | regisseur

1 | reg1

2 | reg2

[pdaoust]

First of all, having two fields named "id_land" in table 1 won't work, so I'll use "uid" in this example for table 1's primary key.

Try this:

SELECT
table1.uid AS uid,
table3.regisseur AS regisseur,
table2.land AS land
FROM
table1,
table2,
table3
WHERE
table1.id_regie = table3.id_regie AND
table1.id_land = table2.id_land;

[pdaoust]

(you don't have to have the extra spaces and returns; I just put them there to clean up the code.)

HTH!
Paul