Define a Data Link Between Queries in a Data Template

 I'm trying to establish a data link between 2 queries in a data template, but I am only getting records for the parent query. Both queries work fine by themselves, but I not able to get the link to work and return combined data. Here is thecode that I am using in the template:

<dataTemplate name="SHC4" dataSourceRef="Oracle BI EE">
 <dataQuery>
  <sqlStatement name="Q1">
   <![CDATA[ 
     SELECT SYS_HLTH_CHK_2108_AP.APPROP AS APPROP_Q1, SYS_HLTH_CHK_2108_AP.AMOUNT AP
     FROM SHC
     ORDER BY SYS_HLTH_CHK_2108_AP.APPROP, AP ]]>
  </sqlStatement>
  <sqlStatement name="Q2">
   <![CDATA[ 
     SELECT SYS_HLTH_CHK_2108_UDO.APPROP, SYS_HLTH_CHK_2108_UDO.AMOUNT UDO