Re: Question: Dynamic Table with Join

[Juan Alvarado <juan@GYSSA.COM.GT>]

we do that with Sybase.  And we create the temp table in a begin-sql and
after reference in the from like a normal table.

I hope this help you

-----Original Message-----
From: Bill Moody [mailto:wmoody@CCMAIL.MULLER.COM]
Sent: Monday, December 28, 1998 10:09 AM
To: Multiple recipients of list SQR-USERS
Subject: Question: Dynamic Table with Join


     Hi,

     I am using sqr 2.4.1 on HP-UX against Oracle 7.3.
     I am trying to pass in a table name, create the table, use sqlldr
to
     populate it, run the query and finally delete the table.

     I cannot create the table. I cannot hard code the table name, it's
     a short lived temp table so it has to be a variable.

     Every example uses only one static table and one variable table.
     I need to use more than one table, e.g.,

     ...
     FROM       alpha a,
                beta  b,
                [static v: $var_table] v
     WHERE ...


     I've tried many variations on this theme.

     Any help is appreciated. Thanks in advance.

     Bill Moody