Hi,

I tried the write up the following SQL statement:

result1 from sql1 = (1,2,3,4,5)
result2 from sql2 = (4,5)
result3 = result1/result2 (or is it result2/result1) = (1,2,3)

What do I have to do to get the (1,2,3) result?  I tried "query EXCEPT
query", but it seems like EXCEPT needs both tables in queries to be of
the same number of columns and column types.  And (any, all, exist)
doesn't seem to be a right solution.

Thanks for help.


- Bernie
begin:vcard 
n:Huang;Bernie
tel;fax:(604)664-9195
tel;work:(604)664-9172
x-mozilla-html:TRUE
org:Environment Canada;Standards and Technology Services
adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada
version:2.1
email;internet:[EMAIL PROTECTED]
title:Programmer
x-mozilla-cpt:;0
fn:Bernie Huang
end:vcard

Reply via email to