SQL Server 2008 combines two queries

Question

I missed something trivial here. This query is not for any reason, in particular, other than trying to practice combining the two queries. The errors I get

Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'inner'. Msg 156, Level 15, State 1, Line 16 Incorrect syntax near the keyword 'as'. 

And request

 select t.countyName, x.countyName from ( SELECT DISTINCT Patient.patientid, tblStateCounties.countyName, Patient.countyCode FROM Patient INNER JOIN tblStateCounties ON Patient.stateCode = tblStateCounties.stateCode AND Patient.countyCode = tblStateCounties.countyCode WHERE (Patient.patientage > 80) ) inner join ( SELECT DISTINCT Patient.patientid, tblStateCounties.countyName, Patient.countyCode FROM Patient INNER JOIN tblStateCounties ON Patient.stateCode = tblStateCounties.stateCode AND Patient.countyCode = tblStateCounties.countyCode WHERE (Patient.patientage < 80) ) as x on t.countyname=x.countyname 

Answer 1

You forgot to use an alias in the first subquery .

Answer 2

 select t.countyName, x.countyName from ( SELECT DISTINCT Patient.patientid, tblStateCounties.countyName, Patient.countyCode FROM Patient INNER JOIN tblStateCounties ON Patient.stateCode = tblStateCounties.stateCode AND Patient.countyCode = tblStateCounties.countyCode WHERE (Patient.patientage > 80) ) rsT inner join ( SELECT DISTINCT Patient.patientid, tblStateCounties.countyName, Patient.countyCode FROM Patient INNER JOIN tblStateCounties ON Patient.stateCode = tblStateCounties.stateCode AND Patient.countyCode = tblStateCounties.countyCode WHERE (Patient.patientage < 80) ) rsX on rsT.countyname=rsX.countyname 

Answer 3

using

 ( SELECT DISTINCT Patient.patientid, tblStateCounties.countyName, Patient.countyCode FROM Patient INNER JOIN tblStateCounties ON Patient.stateCode = tblStateCounties.stateCode AND Patient.countyCode = tblStateCounties.countyCode WHERE (Patient.patientage > 80) ) as t