I have a table which contains two columns, one called Dealers, one called Brands. Any entry in the table represents a dealer stocking a given brand.

What I'm trying to get is a SQL query that allows be to list each dealer that stocks all of a given selection of brands, rather than just returning each dealer that stocks at least one of the aforementioned brands. Anyone got any ideas?

Group by the dealer, return where each item in the subset is there

as a c# linq statement (may need some tweaking)

string[] brands = new string[]{"foo","bar"};
var foo = from t in table
group t by t.Dealer into tDeal
where(t.select(p=>p.Brands).Intersect(brands));

Am I being thick here or isn't the query just select dealer where brand = abc and def and etc?

it is, but as (possibly) a more programmatic approach

Apparently not, having just tried it. Will have a look at the Group By function later.

Edit: Or maybe I was just being an idiot; it's now working.

Sorry for the dumb questions, it's been a while since I used any SQL.