如何在一个查询中查询两个表？
如何合并/合并此查询：
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"
"SELECT 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"
没有找到相关结果
已邀请:
1 个回复
邵酮
-- 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"