Try this, Dennis, You will have to figure out the table names and column
names as appropriate, of course.
SELECT B.multikeycolumns, COUNT(*) AS MyCount +
FROM <B tablename> B, <C tablename> C +
WHERE B.col1 = C.col1 AND B.col2 = B.col2 etc +
GROUP BY B.multikeycolumns
This will return
Col1, Col2, Col ..., MyCount
Albert
Dennis Fleming wrote:
Every time I resort to Declare Cursor, Fetch, etc., I know there was a
Query that would have done the trick. I tried to create a temp
table/view and use group by and having, and then resorted to Select
Into, and Update...
Three tables A, B & C, but A is used just to get the right multi key
to use in B & C.
B is a one-to-many to C
I want to count the rows in C which have the multi key value, and
store that number in a fourth table which has the multi key found in A.
TIA,
Dennis
*****
Dennis Fleming
IISCO
www.TheBestCMMS.com
Phone: 570 775-7593
Mobile: 570 351-5290
