"P. Griffioen" wrote:
> Hello,
>
> I am having troubles figuring out how to get the following result with a sql
> statement:
>
> suppose I have two columns (A and B), populated with the following data :
>
> A B
> 1 1
> 1 2
> 1 3
> 1 4
> 2 1
> 2 2
> 2 3
> 3 1
> 3 2
> 3 3
>
> Now, I want to get a selection of A and B where the value of B is in all
> selections of A(1,2,3,4).
>
> In the example above I want a return of all records -except- of the
> combination 1,4 (because 4 is only present in A(1) and not in the other
> values of A).
>
> I have tried some subselects and a joining of the same table; but i don't
> think that is the right approach.
>
> Thank you in advance for any hints.
>
> best regards,
> Peter
SELECT ...
FROM ...
WHERE ...
AND ...
AND ...
AND ...
Provided you can hard-code 1 through 4. If the number is dynamic and there are
considerations about missing numbers so that you can't just use BETWEEN ... you
are writing a PL/SQL procedure.
--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Jul 10 2003 - 15:05:56 CDT
