Re: select from schema 1 minus select from schema 2

Jeff,

Try this:

  SELECT * FROM schemaA.tableX
  MINUS
  SELECT * FROM schemaB.tableY;

HTH,
Brian

Jeff Kish wrote:
>
> I am using Pro-c (and need to know if this is possible), but this
> could be extended to a general question I guess.
>
> Is it possible to create a result set from selecting from a table in
> one schema and minus'ing a select of identical column types from a
> table in another schema?
>
> Thanks
> Jeff
> e-mail replies are appreciated.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================