Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL? :multiple operations in one SQL query to oracle
The easiest way, if the retuned format is OK, is to use one select from both tables:
SELECT table1.*, table2.* FROM table1, table2;
SELECT t1.*, t2.*
FROM table1 t1,
table2 t2;
> 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 CDT