Select Distinct...........heelllp?

[jonnyb]

Hi,

I have a database table called manufacturers
containing 2 fields ('id' & 'make')
id is auto_increment

I need a query to return DISTINCT data on field 'make'
but also return the corresponding 'id' from each row (not check for DISTINCT there too, because its auto_increment and obviously that would return all records!!)

This is what I have but its throwing an error

Code:
SELECT * FROM Manufacturers
WHERE Manufacturers.make
IN (SELECT DISTINCT Manufacturers.make FROM Manufacturers)
ORDER BY Manufacturers.make

Any help would be fantastic

Regards jb

[njm]

You didn't mention what the error is.

If you're using MySQL < 4.1 as is likely, then the problem is that it doesn't support sub-queries.

hth, njm

[jonnyb]

It's Ok now I found a workaround

GROUP BY was the way to go...thanks anyway