I am trying to figure out a SQL query to do the following
I have a table T1 with primary key column C1 and other info column C2,C3
A second table T2 with D1 foreign key in T1 (C1), and other columns says D2,D3 ...
I want the query to return me something like this :
C1,C2,C3,N where N is the number of rows in T2 with C1 = D1
There is a condition on T1 (where C2 = value1) and on T2 (where D2 = value2)