Professional Web Applications Themes

simple (?) query--help - MySQL

I can't seem to figure out the query for what seemingly should be an easy thing. I have a table "user" which contains the following columns and data: userid locationid 1 1 2 2 3 1 4 3 I need to return a list of locationid's based on a specific userid's locationid. For example if userid equals 1, the query would return userid location 1 1 3 1 Thanks....

  1. #1

    Default simple (?) query--help

    I can't seem to figure out the query for what seemingly should be an easy
    thing.

    I have a table "user" which contains the following columns and data:

    userid locationid
    1 1
    2 2
    3 1
    4 3

    I need to return a list of locationid's based on a specific userid's
    locationid.

    For example if userid equals 1, the query would return

    userid location
    1 1
    3 1


    Thanks.


    Bosconian Guest

  2. #2

    Default Re: simple (?) query--help

    "Bosconian" <bosconianplanetx.com> wrote in message
    news:w6-dnT2MIerY3DreRVn-rgcomcast.com...
    > I need to return a list of locationid's based on a specific userid's
    > locationid.
    >
    > For example if userid equals 1, the query would return
    >
    > userid location
    > 1 1
    > 3 1
    Your description is not clear. Do you mean return all users at the same
    location as the specified userid?

    SELECT u2.userid, u2.locationid
    FROM user AS u INNER JOIN user AS u2
    ON u.locationid = u2.locationid
    WHERE u.userid = 1;

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: simple (?) query--help

    "Bill Karwin" <billkarwin.com> wrote in message
    news:do7gv902d56enews3.newsguy.com...
    > "Bosconian" <bosconianplanetx.com> wrote in message
    > news:w6-dnT2MIerY3DreRVn-rgcomcast.com...
    > > I need to return a list of locationid's based on a specific userid's
    > > locationid.
    > >
    > > For example if userid equals 1, the query would return
    > >
    > > userid location
    > > 1 1
    > > 3 1
    >
    > Your description is not clear. Do you mean return all users at the same
    > location as the specified userid?
    >
    > SELECT u2.userid, u2.locationid
    > FROM user AS u INNER JOIN user AS u2
    > ON u.locationid = u2.locationid
    > WHERE u.userid = 1;
    >
    > Regards,
    > Bill K.
    >
    >
    Bill,

    Sorry for the confusing description, but fortunately you were able to
    decipher my dilemma hopefully with the results example. Your query works
    like a charm--thanks!


    Bosconian Guest

Similar Threads

  1. Simple query, very low performance
    By Bernhard Kornberger in forum MySQL
    Replies: 3
    Last Post: July 6th, 12:27 PM
  2. (simple?) query dilemma--help please
    By Bosconian in forum MySQL
    Replies: 2
    Last Post: November 19th, 02:00 AM
  3. Simple Query for Search
    By amystephenson in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: May 12th, 01:13 PM
  4. [PHP] Simple forms query
    By Matt Matijevich in forum PHP Development
    Replies: 2
    Last Post: July 9th, 04:50 PM
  5. simple query....
    By rodger in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 2nd, 01:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139