Hi,
I am having difficulty on joining multiple tables in XML_TYPE SDS 4.2
Can anyone give any pointers?
For example I have three tables:-
Table 1 is Driver table with column ID
Table 2 is 1 to many of table 1
Table 3 is 1 to many of table 1
All tables join on ID
I have done following in XML_TYPE output
Table 1 ID - Source
Schema 1 (Table1)
Schema 2 (Table3
Iteration for ID = Table 1
Iteration for Schema1 = Inner join - Table1, Table2 ON T1.ID = T2.ID
Where clause on Where Tab = Table2.id = xml_type.ID
Iteration for Schema2 = Inner join - Table1, Table3 ON T1.ID = T3.ID
Where clause on Where Tab = Table3.id = xml_type.ID
When I run this to output to XML template the flow just stalls?
If I run this with just one Schema i.e. Schema1 and remove Schemaa2 it runs no issues?
I assume I have missed something but just cannot put my finger on it?
Any help appreciated
Many THanks
phatz (BOB member since 2009-04-21)