MySQL Join Query

Question

I am having trouble with a MySQL join query - unfortunately I am not too good with joins.

Table page_section:
-------------------
id
page_id
name
display_order


Table page_section_sub:
-----------------------
id
page_section_id
page_id
content

One page_section can have many page_section_sub

On my page I want to display rows from page_section_sub ordered by page_section.display_order

Currently I have this:

$query="SELECT * FROM page_section_sub WHERE page_section_id IN (1,2,3,4,5) 
ORDER BY display_order";

But this is not working as it is missing the join. How do I do this?

something like that: select pss.* from page_section_sub pss join page_section ps on pss.page_section_id = ps.id where ps.id between 1 and 5 order by ps.display_order — greut
– greut, Commented Jan 5, 2012 at 17:37

D'Arcy Rittich · Accepted Answer · 2012-01-05 17:36:27Z

2

select pss.*
from page_section_sub pss
inner join page_section ps on pss.page_section_id = ps.id
where pss.page_section_id in (1, 2, 3, 4, 5)
order by ps.display_order

answered Jan 5, 2012 at 17:36

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2012-01-05 17:42:11Z

0

Try this way:

SELECT * FROM page_section
LEFT JOIN page_section_sub ON page_section.page_id = page_section_sub.page_id
WHERE page_section_id IN (1,2,3,4,5) 
ORDER BY display_order;

edited Jan 5, 2012 at 17:42

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

answered Jan 5, 2012 at 17:35

Petar Sabev

8686 silver badges12 bronze badges

Comments

Rahul · Accepted Answer · 2012-01-05 17:49:00Z

0

Try this:

Select page_section_id.* from page_section_id natural join page_section 
WHERE page_section_id IN (1,2,3,4,5) order by page_section_id.display_order

edited Jan 5, 2012 at 17:49

answered Jan 5, 2012 at 17:41

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Collectives™ on Stack Overflow

MySQL Join Query

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related