Ysgrifennodd bruce:
hi peter.
thanks, the solution you gave me is close...!!
<snip>
what i really want to get is:
+--------------+
| universityID |
+--------------+
| 2 |
| 3 |
+--------------+
which would be the unique 'id's.....
i've tried to do a 'limit' and group, but i'm missing some thing...
thanks
-bruce
SELECT DISTINCT ...
I didn't realise you only wanted the distinct values.
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]