Hey all,

I'm having what i think is a pretty simple problem, but i just can't seem to get the damn thing to work!

i have a command:

SELECT service_name FROM servers, services WHERE services=service_id;


Now this one works(basically, it gets the service_name attached to each server). My problem is that the service_id is a list of values, and i want it to list the names of all those services, not just the first one.

Is this possible? The list of values is in the db like this: 1,2,3,4,5

should the data be in a different manner(spaces instead of commas...)

thanks for any help you can give me!

Miche