Hello everyone,
Here I am not a beast in SQL and I want to make a selection a bit special. Only I do not know how.

I have a table that looks like this:

id | en_city | fr_city
---------------------------------


- It is possible that the two fields in the same row are filled.
- One of two fields is always (at least) completed.


I want to select all the fields separately to create a list box.
Only I can not do too much.
Here is my current query:

<? Php
$ Sql = "SELECT DISTINCT en_city, recruitment fr_city FROM WHERE country = '".$ Country."'"
?>

It sends me a duplicate, in case there is a field and a field en_city fr_city identical.
The problem is that I do not know how to contact the SQL command for the two fields at the same time?


Does anyone know a specific syntax or command to do what I want?

In advance thank you.

and "recruitment" & "country" come from where?

are they important?

build two query statements, one for each city column, and use union to bring back unique results.

SELECT en_city, ...
UNION
SELECT fr_city, ...

remember though, the entire row must be unique to avoid duplicates

Originally Posted by chrishirst

and "recruitment" & "country" come from where?

If you include them in a query they have to be in the table.