多个表 联表

查询

SELECT bs.bs_id,u.u_nick,ac.a_newprice, bs.bs_sqsj 
FROM  `a_business` as bs left join `c_user` as u on bs.bs_buyerid=u.u_id  left join `a_saction` as ac 
on bs.bs_actionid=ac.a_id  where  bs_status=6 and  bs_sqsj > '2021-06-01' and bs_sqsj < '2021-12-30' ;