Re: Query Help - Stumped...

I do not understand your question.

Why is 2 not in your result set? It also has 'a'.

What ist the connection between your combinations (a, c) and (b, g) and the result? Which table contains the rows (a, c) and (b, g) or are these two rows (a), (c) and (b), (g)? It's a bit confusing because normally you use your tuple notation (a, c) for one row, not for several. You should write {(a), (c)} and {(b), (g)}.

For what do you need table a and table b?

Martin

thecake_at_my-deja.com wrote:
>
> Please Help! I have a relational database question regarding how to
> get the information I need out of the database with 1 single line of
> SQL that answers the following question:
>
> Using TABLE Z, find all TABLE A records that have ANY of these TABLE B
> records (b, g) OR ALL of these TABLE B records (a,c). The result
> should return:
>
> 1 (because it has BOTH A,C)
> 3 (because it has b)
> 4 (because it has b – also happens to have BOTH A,C)
> 5 (because it has g)
> 6 (because it has BOTH A,C)
>
> PLEASE KEEP IN MIND that the two sets above (b, g) and (a, c) could
> actually contain many more items in the real world! Feel free to reply
> here or email at:
>
> thecake_at_writeme.com - THANKS in Advance!
>
> Here is a simple example of the data (THIS IS ONLY AN EXAMPLE. I used
> numbers and letters for in the hopes of being clear, the real data is
> obviously primary keys of INT).
>
> TABLE A
> COL A1
> 1
> 2
> 3
> 4
> 5
> 6
>
> TABLE B
> COL B1
> a
> b
> c
> d
> e
> g
>
> TABLE Z
> COL A1 COL B1
> 1 a
> 1 c
> 2 a
> 2 d
> 3 a
> 3 b
> 3 e
> 4 a
> 4 b
> 4 c
> 5 g
> 6 a
> 6 c
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Apr 30 2000 - 00:00:00 CDT