MS SQL Server MSEQ - Re: Selecting data from one table based on conditions in another t

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Selecting data from one table based on conditions in another t

John Steen

2006-02-07, 8:24 pm

Thanks much, Hugo, the query seems to have worked.

--
John Steen
remove (nospam) from e-mail address to send me a message

"Hugo Kornelis" wrote:

> On Thu, 2 Feb 2006 11:50:40 -0800, "John Steen"
> < moderndads(nospam)@h
otmail.com> wrote:
>
>
> 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
>

Sponsored Links