<moderndads(nospam)@hotmail.com> wrote:

>I'm used to doing simple queries from individual tables, so I hope someone
>can help with this.
>
>I need to select unique data from a column in table1 based on the value of a
>column in table2. The data in the column of table1 is not all unique, so I
>also need to filter out extra occurrances of of the data. So if the name
>JOHN SMITH appears 27 time in the column in table 1, I only want to return
>one instance of the name.
>
>Thanks in advance.

"Hugo Kornelis" wrote:

> On Thu, 2 Feb 2006 11:50:40 -0800, "John Steen"
> <moderndads(nospam)@hotmail.com> wrote:
>
> >I'm used to doing simple queries from individual tables, so I hope someone
> >can help with this.
> >
> >I need to select unique data from a column in table1 based on the value of a
> >column in table2. The data in the column of table1 is not all unique, so I
> >also need to filter out extra occurrances of of the data. So if the name
> >JOHN SMITH appears 27 time in the column in table 1, I only want to return
> >one instance of the name.
> >
> >Thanks in advance.
>
> Hi John,
>
> Based on your very vague narrative, here's a shot in the dark:
>
> SELECT DISTINCT Table1.SomeColumn
> FROM Table1
> INNER JOIN Table2
> ON Table2.LinkingColumn = Table1.LinkingColumn
> WHERE Table2.OtherColumn = @WhateverYouLookFor
>
> If this is not what you want, then please post better specification. A
> good explanation of what you need to post and how you can assemble it is
> to be found at www.aspfaq.com/5006.
>
> --
> Hugo Kornelis, SQL Server MVP