Help!! XML Data

[McNasti]

I have two "tables" i need to report from. I'm reporting from a XML Datasource so they're not actually tables, im using CR Version 10.

Table A Contains
Location_Id (PK)
Location Name

Table B Contains: A person has 2 locations.
Person_Id(PK)
Location_id_1(FK)--References Location_id in Table A
Location_id_2(FK)--References Location_id in Table A
Person_Name

Id Like my report to look something like this:

Person_Name Location_1 Location_2
----------- ---------- ----------
Joe New York San Fran


Given that I can't write SQL. Is there anyway I can a accomplish this?



Thanks for your ideas

 

[synapsevampire]

Add the Table B, and then add the Table A twice (it will prompt for an alias).

Left Outer Join from B.Location_id_1->A.locationID->
and then from
Left Outer Join from B.Location_id_2->AAliased.locationID

-k

 

[McNasti]

Thanks much...that worked!

 

[McNasti]

Hi,

How would I accomplish a left outer join from an XML datasource. It won't allow it fro within the Database Expert. I'm you using the SELECT EXPERT to establish my relationships.

So using the example above in the select expert i have.

B.LocationID = A.LocationID

I need some outer join construct on Table B.

Thanks