the first query returns:

MonthYearCity CCG AttendedCity CCG DNACancelled

Oct2014010

Feb2015000

Jan2015100

Mar2015210

May2015010

The second query returns

NHSNumber DateOfBirth DateReferralReceived OrganisationCode

121421421 1981-03-14 2015-03-14 C43653

I want the query to count the number return in query 2 and return this as a column in query 1. Is there any more infomation I can provide to make it easier