Query second table based on first query response?

ziycon

Ok, i got the main query working, my issue is that the GROUP BY isn't working, its should only show one of each location:

Expand|Select|Wrap|Line Numbers

 SELECT _teamdb_country.name FROM _teamdb, _teamdb_country WHERE _teamdb.country NOT IN (0) AND _teamdb.country = _teamdb_country.id ORDER BY _teamdb_country.name ASC
 

It should look like:
France
Germany
UK

But its outputting this:
France
Germany
Germany
UK
UK
UK

ziycon

Sorted, I was using an ORDER BY instead of a GROUP BY.

Query second table based on first query response?

re: Query second table based on first query response?

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about