Joined: 29 May 2004
|Posted: Fri Sep 22, 2017 12:06 am Post subject: Add column with count of rows within distinct
I have a case with two tables to join and three of the columns of the first table should be distinct. I want those three columns and one column of the second table and the count of how many rows there are inside of the distinct group.
So table TA contains A, B, C, D
table TB contains B, E
how to get the distinct (A, B, C) and E and the count of the rows inside of the distinct (A, B, C).
Thanks very much for any help!