Koen Verbeeck (7/30/2012)
Something like this?
SELECT ID, Name, Type, CountType = COUNT(Type)
FROM Table1 t1 INNER JOIN Table2 t2 ON t1.Type = t2.Type
GROUP BY ID, Name, Type
create a dataset using the above code as a reference.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: