Re: help; a challenging SQL request
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 29 Jun 2011 18:36:01 +0200
Message-ID: <9712joFcajU1_at_mid.individual.net>
On 29.06.2011 17:08, charles wrote:
> Group,
>
> I need to write a SQL which find all the match recording for a
> particular person
>
> For example
> COL1 COL2
> john a
> john b
> john c
> joe a
> joe c
> tim a
> tim b
> tim c
>
> I would like to find all the person who has the same entry as john (a,
> b,c ), which tim is.
>
> How should i build that SQL?
>
> Thanks for your help
Date: Wed, 29 Jun 2011 18:36:01 +0200
Message-ID: <9712joFcajU1_at_mid.individual.net>
On 29.06.2011 17:08, charles wrote:
> Group,
>
> I need to write a SQL which find all the match recording for a
> particular person
>
> For example
> COL1 COL2
> john a
> john b
> john c
> joe a
> joe c
> tim a
> tim b
> tim c
>
> I would like to find all the person who has the same entry as john (a,
> b,c ), which tim is.
>
> How should i build that SQL?
>
> Thanks for your help
It seems you do not read replies you get. And why do you open a new thread?
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Wed Jun 29 2011 - 11:36:01 CDT