php高效多表联查union all 、left join 的结合使用:

从文章表中联查指定数据，并以catid为指针从分类表查询对应的分类名称。可广泛使用于制作任意CMS模板时自主调用数据库数据。-php efficient multi-table joint investigation union all, left join, in combination: From the article linked in the table specify the data search, and classification catid query for the pointer from the corresponding category name. Can be widely used in the production of any CMS template database is called data independence.