Hi,
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!
Regards,
Crox
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!
Regards,
Crox