java sql quries help

Hi

I confuse on how to transform set difference query into java code to work in java program.

how do you write a sql query in java that perform set difference.

R - S

R Except S (in oracle)

I want to get all the elements in Set R that are not available in Set S

I want to write following set difference operation in java

( selectDOCID, COPYNO

fromCOPY

EXCEPT

select DOCID, COPYNO

fromRESERVES

}

how do convert the above operation to work in java?

And also how do you do it for set intersection?

Thanks

[599 byte] By [ms01a] at [2007-11-26 12:22:35]