Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: Help with some sql

    Using mysql 4.1

    User, Map, and Bookmark tables.
    Bookmark has map_id and user_id

    What I'd like is given a map id, i'll like all of the users with that map id in the bookmark table. Can anybody point me in the right direction?

  2. #2
    Join Date
    Jun 2005
    Posts
    23
    Code:
    SELECT u.id
    FROM User u
    INNER JOIN 
    Bookmark b
    ON u.id=b.user_id
    WHERE 
    b.map_id=value

Posting Permissions

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