November 19th, 2002, 04:33 AM
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...
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?
November 19th, 2002, 05:00 AM
k got it...
thx for the efforts