xsql

From: kella <ksella76_at_yahoo.co.uk>
Date: 12 Aug 2002 17:56:19 -0700
Message-ID: <3c1b130d.0208121656.3ae5e6e4_at_posting.google.com>

hi,
[Quoted] does xsql allow for nested multiple sql queries, such as:

<?xml version="1.0"?>
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
SELECT * FROM Region
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
SELECT * FROM Company
</xsql:query>
</xsql:query>

[Quoted] And if so, is it possible for results from an earlier query to be used elsewhere such as:

<?xml version="1.0"?>
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
[Quoted] SELECT regionname FROM Region
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
<!-- regionname below is the regioname from above -->
[Quoted] SELECT companyname FROM Company where regioname=regionname
</xsql:query>
</xsql:query>

Thanks

jim Received on Tue Aug 13 2002 - 02:56:19 CEST