subjectValue - Table A Request_Id - Table A Survey_Id - Table C SELECT TableA.SubjectValue FROM TableB INNER JOIN TableA ON TableB.ID = TableA.Request_ID INNER JOIN Table C ON TableB.Details_ID = TableC.IDThere are 3 different survey Id's so the count will need a where clause on the survey_id. May I also add, that I would like all the separate counts of survey id returned in the same grouped by row. Hope that makes sense. Many thanks in advance.
Answer by Oleg ·