Group help

[Stephen68]

Hello!

 

I have a table and I would like to group all the values that are the same. Not sure if you can even do this, look around and didn't

find what I was trying to do. Anyway here is what I'm trying to do.

 

Table has a field name of "weight" (lets say) and a field name of "name". I wold like to group all the same value that are in the

"weight" field that have the value of ?? in the "name" field. I hope this makes some sense to you fine people.

 

Thanks for you help

Cheers!

[trq]

SELECT name, weight FROM tbl GROUP BY weight