嵌套连接查询
SELECT *
FROM bas_XX v
INNER JOIN ( select * from bas_DD where id=210344) sON v.SHOPID = s.id;