mysql - 与结果表连接

Question

p.slugUrl AS resultslug, p.id, m.slugUrl, m.categoryParent, pa.pageId, pa.categoryId from tcs_pagecontents as p,tcs_pageassociation as pa, tcs_menucategory_site as m where p.id=pa.pageId and pa.categoryId=m.id ;

这将返回一个具有以下结构的表(假设该表为 P)

resultslug
id
slugUrl
categoryParent
pageId
categoryId

此外，我想将此结果表连接到另一个表，其中 P.categoryParent = T.id，这里 T 是我想要获取以下列名称的另一个表

    P.resultslug
    P.id
    P.slugUrl
    P.categoryParent
    P.pageId
    P.categoryId
    T.slugUrl
where  P.categoryParent = T.id; 

我这里一片空白。任何想法将不胜感激。提前致谢。

Answer 1

只需像其他表一样加入该表即可。

select p.slugUrl AS resultslug, p.id, m.slugUrl, m.categoryParent, pa.pageId, pa.categoryId, T.slugURL 
from tcs_pagecontents as p
join tcs_pageassociation as pa on p.id=pa.pageId 
join tcs_menucategory_site as m on pa.categoryId=m.id
join another_table T on m.categoryParent = T.id;