Select Code to Download

Class Data

...
End Class_Terminate

End Class

SQL = new Data
DB2 = new Data
...
LOCATIONS.ADDRESS2, LOCATIONS.CITY, LOCATIONS.STATE, LOCATIONS.ZIP FRO
+M
EMPLOYEES INNER JOIN LOCATIONS ON EMPLOYEES.LOCATION_ID = LOCATIONS.LO
+CATION_ID
WHERE EMPLOYEES.EMP_ID = ?", (employee_id)))

<FAV_COLOUR>
    <name>John Q. Public</name>
    <emp_id>999999</emp_id>
    <fav_colour>blue</fav_colour>
</FAV_COLOUR>

<LOCATION>
    <ADDRESS1>. . .</ADDRESS1>
...
    <STATE>. . .</STATE>
    <ZIP>. . .</ZIP>
</LOCATION>

DOMSQL.appendChild(DOMDB2.selectSingleNode("//LOCATION"))

<FAV_COLOUR>
    <name/>
...
        <ZIP/>
    </LOCATION>
</FAV_COLOUR>