How can I query two tables in one query?

How do I merge/combine this query:

SELECT pages.*, pages_content.title, 
    pages_content.label FROM pages, 
    pages_content WHERE
    pages.menu='top' AND pages_content.parent = 
    pages.ID order by 
    pages.sequence ASC"

Into this one:

"SEL开发者_StackOverflowECT a.ID, a.parent, a.title, a.label, a.link, a.sequence, Deriv1.Count  FROM 
pages a  LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM 
pages WHERE menu='top' GROUP BY parent) Deriv1 ON a.ID = Deriv1.parent 
WHERE a.parent=" . $parent1 . " AND menu='top' order by sequence ASC"

The last query works but i need to replace the title and label data form another table (pages_content) as is done in the first query

How on Earth can I combine the two or fit in two? left outer joins

Now, to make the second query

-- Original select clause
SELECT a.ID, a.parent, a.title, a.label, a.link, a.sequence, Deriv1.Count  
-- Add additional columns
,b.title,b.label_data
FROM pages a  
-- Add the page_content table
JOIN pages_content b on b.parent=a.id
LEFT OUTER JOIN 
(SELECT parent, COUNT(*) AS Count FROM pages 
        WHERE menu='top' GROUP BY parent) Deriv1 ON a.ID = Deriv1.parent 
WHERE a.parent=" . $parent1 . " AND menu='top' 
order by sequence ASC"