In article <9d5b8437.0208210658.2e235cdf_at_posting.google.com>,
rhizopod_at_eudoramail.com says...
> I have a query where I want to extract data from three joined tables.
> Two of them are already defined Oracle tables, the third is a result
> of a query on a different Oracle table. Using the tool EZSQL I can
> use something of the form:
>
> SELECT table1.id, table2.crap, subtable.monkey, z FROM table1, table2,
> (SELECT id, blah1, blah2, FROM table3 WHERE ... ) subtable WHERE
> table1.id = table2.id AND
> table1.id = subtable.id
>
> That is, I can use the symbol "subtable" after the subquery then refer
> to its fields elsewhere in the query. However, I cannot do this in
> Visual Basic 6.0. How do I refer to fields from the subquery (I have
> to join on one of these fields) elsewhere in the query in Visual
> Basic? Maybe it is something simple that I am missing (hopefully).
> Thanks,
>
> Arjun
>
How are you accessing the data (ODBC, OLEDB, OO40)? Are you using
Command objects? Recordsets? Straight SQL? What version of Oracle?
Help us help you :)
Received on Wed Aug 21 2002 - 10:12:54 CDT
