Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

left outer join

Status
Not open for further replies.

MrBillSC

Programmer
Aug 6, 2001
592
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top