Hi,
I have 2 tables: table "clients" and table "area".
Clients table:
Client_number | Client_name | Client_language | Area_number |
---|---|---|---|
1 | Walter | Dutch | A1 |
2 | Maya | French | B1 |
3 | Tom | French | C1 |
Area table:
Area_number | Area_name | Area_language |
---|---|---|
A1 | Moeskroen | Dutch |
A1 | Mouscron | French |
B1 | Meyerode (Saint Vith) | French |
B1 | Meyerode (Sankth Vith) | German |
C1 | Bullingen | German |
In the result of the query I want to display the area_name that corresponds with the client_language from the clients table. So the result of the query must look like this:
Client_number | Client_name | Client_language | Area_number | Area_name |
---|---|---|---|---|
1 | Walter | Dutch | A1 | Moeskroen |
2 | Maya | French | B1 | Meyerode (Saint Vith) |
3 | Tom | German | C1 | Bullingen |
Someone who can help me with the query?
Thanks a lot