#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    42
    Rep Power
    13

    Question help on 3 table join query?


    i'd like to know how to do a select statement in mysql - the mysql forum is currently down...

    Problem:
    I have 3 tables:

    owners table, login table, and toys table

    the owners table primary key is owner_id.
    the login table primary key is login_id
    the toys table primary key is toys_id

    owner_id is a foreign key in the toys table
    login_id is a foreign key in the owners table

    i want the owner's "firstname and lastname" from the owner table, the "username" from the login table WHERE the owner_id in the toys table = 1.

    can i do this with only one query? if so, what is the query?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    42
    Rep Power
    13
    k got it...
    thx for the efforts

IMN logo majestic logo threadwatch logo seochat tools logo