Skip navigation links

MySQL Forums :: Newbie :: JOIN tables


Advanced Search

JOIN tables
Posted by: Ben Graham ()
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.

Options: ReplyQuote


Subject Written By Posted
JOIN tables Ben Graham 11/03/2009 05:37AM
Re: JOIN tables Chad Bourque 11/03/2009 07:49AM
Re: JOIN tables Ben Graham 11/03/2009 09:55AM
Re: JOIN tables Chad Bourque 11/03/2009 11:31AM


Sorry, only registered users may post in this forum.