JOIN tables
Date: November 03, 2009 05:37AM
Hi. I'm using JOIN for the first time and it's difficult to grasp the complexity of it but I'll explain my situation.
I've got 3 tables I want to get info from.
table_1 contains attribute_id, firmware_id (both PKs)
table_2 contains attributes, such as id (PK), definition_id, value
table_3 contains attribute definitions, id (PK), name, description
tabel_1.attribute_id is a foreign key, linked to table_2.id
What I want is to get a result set that contains all of a firmware's attribute ids, the info associated with that attribute id, and the info attribute definitions, associated with that info.
I know JOINS could help me but I just can't get my head around it. Any help would be greatly appreciated.
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.