Hi

I am having problems joining 2 results sets (created using multilist method) together.  I used the multilist to bring back the details in all the lists in the site collection for a given name.  I then want to join the results together where the subsites are the same - there is no actual field in common between the two lists. 

I tried to do using the rstLabel field created by enesys, thinking it would create the field for each result set, but i guess that isnt the case.  Here is the code i tried:

<root xmlns="http://enesyssoftware.com/schemas">
        <multiList title = "Project Details &amp; Status" relativeSiteUrl="/sites/npi/" type="RollUpList"  tableName="ProjectDetailsStatus">
              <fields>Title,  Product_x0020_Family, Project_x0020_Status</fields>
             <query></query>
       </multiList>
      <resultSet>ProjectDetailsStatus</resultSet>

        <multiList title = "Project Dates" relativeSiteUrl="/sites/npi/" type="RollUpList"  tableName="ProjectDates">
              <fields>Title, Kick_x002d_Off, _x0044_R4, QR, PSU, Target_x0020_FCS</fields>
             <query></query>
       </multiList>
      <resultSet>ProjectDates</resultSet>

<sqlOp op="join">
      <dstTableName>StatusAndDates</dstTableName>
      <parentTableName>ProjectDetailsStatus</parentTableName>
      <childTableName>ProjectDates</childTableName>
      <parentFieldName>rstLabel</parentFieldName>
      <childFieldName>rstLabel</childFieldName>
</sqlOp>
<resultSet>StatusAndDates</resultSet>
</root>

This is fundamental to the report i am building - there are several sites in a site collection for each project.  Each site has identical lists.  The RS report needs to group by project and display the contents of each list for each site.  I would greatly appreciate any help!

thanks.

that query is here - joining on the title column:

<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
        <multiList title = "Project Summaries" relativeSiteUrl="/sites/npi/" type="RollUpList"  tableName="Summaries">
              <fields>Title, Summary, Summary_x0020_Type  </fields>
             <query></query>
       </multiList>
      <resultSet>Summaries</resultSet>

        <multiList title = "Project Details &amp; Status" relativeSiteUrl="/sites/npi/" type="RollUpList"  tableName="ProjectDetailsStatus">
              <fields>Title,Product_x0020_Family, Project_x0020_Status</fields>
             <query></query>
       </multiList>
      <resultSet>ProjectDetailsStatus</resultSet>

<sqlOp op="join">
      <dstTableName>Result</dstTableName>
      <parentTableName>Summaries</parentTableName>
      <childTableName>ProjectDetailsStatus</childTableName>
      <parentFieldName>Title</parentFieldName>
      <childFieldName>Title</childFieldName>
</sqlOp>
<resultSet>Result</resultSet>