Re: SQL? :multiple operations in one SQL query to oracle

From: Ian C. Sellers <ian_at_mystical.net>
Date: 1997/07/07
Message-ID: <33C155CF.A78C3E2E_at_mystical.net>#1/1


The easiest way, if the retuned format is OK, is to use one select from both tables:

SELECT table1.*, table2.* FROM table1, table2;

  • or, using column aliases,

SELECT t1.*, t2.*
FROM table1 t1,

            table2 t2;



James Mercer wrote:

> When I type something like:
>
> select * from table1; select * from table2
>
> from VB or in the Oracle ODBC test program, I get an invalid character
>
> error (I'm assuming on the ';'). How else could I send two selects in
> one
> SQL statement?
>
> thanks,
> James Mercer
Received on Mon Jul 07 1997 - 00:00:00 CEST

Original text of this message