Re: Multiple selects

a different take on this is maybe you could use a union e.g.

Select * from dba where fielda like "jiberish" union
select * from dbb where fieldd not like "jiberish"

This is assuming the tables have the same columns. Obviously separate statements within a script would work, too.

jimbob4334_at_my-deja.com wrote in message <7qj909$goj$1_at_nnrp1.deja.com>...
> Hi,
>
>
>Is there a way to have multiple selects using SQL Plus 8 on an NT?
>
>I want to do something like.
>
>spool filename
>Select * from dba where fielda like "jiberish"
>select * from dbb where fieldd not like "jiberish"
>
>spool off
>
>
>--
>Check out http://www.ina.net/eprofits/jeferree
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 01 1999 - 23:19:16 CDT