I am new to writing xml code. I am linking two tables and I want to select the first table records whether or not there are linked records in the second table. When I enter the following code the report give me errors:
<table type="left_outer_join">
<table type="table" name="VP_PTypeCounts" alias="vp_tc"/>
<table type="table" name="VP_Permits" alias="vp_p" />
<condition type="equals">
<field tablename="vp_tc" fieldname="ptypeid"/>
<field tablename="vp_p" fieldname="ptypeid"/>
</condition>
</table>
It doesn't like the left_outer_join. What am I doing wrong?
Thanks,
MrBill
<table type="left_outer_join">
<table type="table" name="VP_PTypeCounts" alias="vp_tc"/>
<table type="table" name="VP_Permits" alias="vp_p" />
<condition type="equals">
<field tablename="vp_tc" fieldname="ptypeid"/>
<field tablename="vp_p" fieldname="ptypeid"/>
</condition>
</table>
It doesn't like the left_outer_join. What am I doing wrong?
Thanks,
MrBill