Hi. Hope this is the correct list. I'm strugling with a right and left join query: SELECT category.name AS cname, service.name AS tname, service.id AS sid FROM provider LEFT JOIN providerservice ON provider.id = providerservice.provider_id RIGHT JOIN service ON providerservice.service_id = service.id INNER JOIN category ON service.category_id = category.id WHERE providerservice.id IS NULL && provider.id = '1' ORDER BY category.name, service.name As you can see, I want to get all services that the provider with provider.id=1 doesn't have. this worked with Mysql 4.1, but doesn't work with 5.0. Kristian
