SELECT * FROM (sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id) INNER JOIN sst_admin ON sst_business.uid = sst_admin.id (sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id)这个能得到数据?
SELECT * FROM sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id--sst_business内链sst_region INNER JOIN sst_admin ON sst_business.uid = sst_admin.id --sst_region内链sst_admin --如果你说 (sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id)这样能得到那就是这里错了
单独运行SELECT * FROM sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id--sst_business内链sst_region 是没有问题的有几条就查询几条
如果条件一定要这样链 。 聚集 SELECT * FROM sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id INNER JOIN sst_admin ON sst_business.uid = sst_admin.id group by 你的主键
(sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id)这个能得到数据?
INNER JOIN sst_region ON sst_business.region_id = sst_region.id--sst_business内链sst_region
INNER JOIN sst_admin ON sst_business.uid = sst_admin.id --sst_region内链sst_admin
--如果你说 (sst_business INNER JOIN sst_region ON sst_business.region_id = sst_region.id)这样能得到那就是这里错了
INNER JOIN sst_region ON sst_business.region_id = sst_region.id--sst_business内链sst_region
是没有问题的有几条就查询几条
SELECT * FROM sst_business
INNER JOIN sst_region ON sst_business.region_id = sst_region.id
INNER JOIN sst_admin ON sst_business.uid = sst_admin.id group by 你的主键