数据表多表关联查询简单举例

SELECT p.status,p.title,p.userid,m.userid,c.userid FROM b2b_sell p

left join b2b_company c on p.userid = c.userid

left join b2b_member m on p.userid = m.userid

where p.status = 1 ORDER BY p.pid desc limit 1,10