Re: help; a challenging SQL request

From: jsfromynr <jatinder.1975_at_gmail.com>
Date: Sun, 3 Jul 2011 23:33:39 -0700 (PDT)
Message-ID: <ae1bde4e-97fa-4633-b282-af628f6353a3_at_j14g2000prn.googlegroups.com>

On Jul 1, 6:17 pm, charles <dshprope..._at_gmail.com> wrote:
> > He's using Google Groups which has been broken for the last few days.
> > It's not showing any usenet posts since the 27th. So he won't see
> > either his original post, or any replies (including these).
>
> > --
> > Preston.
>
> Thanks Preston for explain to me.  I did not see my postings, thought
> my messages did not go through.

Hello There,

See if this helps.

Select t2.Col1 from tmp_data t1
Inner Join tmp_data t2 on t1.Col2=t2.Col2 And t1.Col1='john' and t2.Col1!='john'
group by t2.Col1
having COUNT(distinct t2.Col2) =
(
Select count(distinct Col2) from tmp_data Where Col1='john' )

With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com Received on Mon Jul 04 2011 - 01:33:39 CDT