Here is my query that I'm using:
<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
<list listID="{7272B626-BD81-45D1-BA8E-6DF8EDDA1C4C}" relativeSiteUrl="/" tableName="RecProgramSchedule" expandFirstDate="2007-01-01T00:00:00" expandRecurrent="true" expandLastDate="2015-12-31T00:00:00">
<fields></fields>
<query>
<Where>
<Eq>
<FieldRef Name='fRecurrence' />
<Value Type="Boolean">1</Value>
</Eq>
</Where>
</query>
</list>
<list listID="{7272B626-BD81-45D1-BA8E-6DF8EDDA1C4C}" relativeSiteUrl="/" tableName="ProgramSchedule" expandRecurrent="false">
<fields></fields>
<query>
<Where>
<And>
<And>
<Geq>
<FieldRef Name='EventDate' />
<Value Type='DateTime'>@StartDate!</Value>
</Geq>
<Leq>
<FieldRef Name='EndDate' />
<Value Type='DateTime'>@EndDate!</Value>
</Leq>
</And>
<Eq>
<FieldRef Name='fRecurrence' />
<Value Type="Boolean">0</Value>
</Eq>
</And>
</Where>
</query>
</list>
<sqlOp op="union">
<dstTableName>Merged</dstTableName>
<parentTableName>RecProgramSchedule</parentTableName>
<childTableName>ProgramSchedule</childTableName>
<labelColumn>true</labelColumn>
<parentLabelValue>Recurrent</parentLabelValue>
<childLabelValue>Non Recurrent</childLabelValue>
</sqlOp>
<resultSet>Merged</resultSet>
</root>
There are recurring items that have been removed that are still showing up. Is there any way to correct this?