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

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

I pulled the following from a project of mine, both work fine:

Sql1 = "SELECT DISTINCTROW WeekC.W0, Avail.Emp " & _

        "Master.E10, Master.Scope, Master.Type, Master.GP1, " & _
	"FROM (Avail INNER JOIN WeekC ON Avail.WCode = WeekC.WCode)"

Sql1 = "SELECT [Code], [Emp], [Date], [Prev], [Pos], " & _
       "[RHr], [RRate], [OHr], [ORate], [Type], [Acct]" & _
       " From TTEnt, Rates" & _
       " Where (TTEnt.Pos = Rates.Desc)"

Dean Received on Fri Jul 04 1997 - 00:00:00 CEST