Re: SQL question

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

select userID, asset
from tbl
where asset in (select asset from tbl where userid = 'user1')

Charles

On Wed, Oct 22, 2008 at 10:41 AM, Tim Gornall <tgornall@xxxxxxxxxx> wrote:
> I ended up doing this in two parts, and was wondering how/if it could be
> done in one statement.  The table contains two columns: UserID and Asset.
>
> I need to determine all the assets associated with UserID = user1.  Then
> using that result set, all the users associated with those assets.
>
> The end result would look something like this:
> User1  asset1
> User1  asset2
> User1  asset3
> User5  asset2
> User8  asset1
> User8  asset3
>
> Anyone want to take a stab at it?
> Thanks, Tim
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.