hi...
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooID size id
1 2 1
2 5 2
1 5 3
if i do a query
select * from dog where fooID='1';
i get
1,2,1
1,5,3
how can i do a distinct/group by select such that if i do a select on
fooID=1, i'll only get '1,2,1', or '1,5,3', meaning that i don't get both of
the items where fooId=1.
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
