Question: Dynamic Table with Join

[Bill Moody <wmoody@CCMAIL.MULLER.COM>]

     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