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
James Mercer wrote:
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