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

James Mercer <jpmercer_at_concentric.net> wrote in article <01bc8833$b596cd80$7cd09bcf_at_jpmercer.concentric.net>...
> 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?
>

The way I do it:

DB.Execute "SELECT * FROM tablename1"
DB.Execute "SELECT * FROM tablename2"

However, if you are trying to do a join between two tables then the syntax is different. Look at VB help under SELECT with JOINS. eg/
SELECT fields
FROM table1 INNER JOIN table2
ON table1.field1 compopr table2.field1

Telmo Silva

-- 
_______________________________
Mail: telmo_at_ica.net
URL: http://www.ica.net/pages/telmo