1,105,534 Community Members

SELECT and display records from three linked Tables in MySQL

Member Avatar
patrick1981
Newbie Poster
19 posts since Feb 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

I have three table that are linked like this. Each content is linked to a category and each category is linked to a section. Like this

sections_table
-section_id
-section_name

categories_table
-category_id
-section_id
-category_name

contents_table
-content_id
-category_id
-content_title
-content_description

I want to write a query to display only content from a particular section and I am having difficulty, can someone help me with writing my query? Thank you

Member Avatar
t_thakar
Newbie Poster
18 posts since Mar 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 
SELECT `contents_table.content_id`, `contents_table.content_title`, `contents_table.content_description`
From `contents_table`, `categories_table`, `selection_table`
WHERE `selection_table.selection_id` = selectedID
AND `selection_table.selection_id` = `categories_table.selection_id`
AND `categories_table.category_id` = `contents_table.category_id`

I think this should do it

Member Avatar
rajeevphp2011
Light Poster
26 posts since Nov 2011
Reputation Points: -3 [?]
Q&As Helped to Solve: 6 [?]
Skill Endorsements: 1 [?]
 
0
 
Question Answered as of 2 Years Ago by rajeevphp2011 and t_thakar
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: