摘要:
表关系图:需求:我想要查询的数据结果是:我们可以内连接:select s.id,s.name,srt.typeId, stt.name as TypeName from scenics as sINNER JOIN(select * from scenics_type) srt on srt.scenicsId=s.idINNER JOIN(SELECT * from scenicstype where deleted=0)stt on stt.id=srt.typeId得到结果是:显然我们需要分组,合并一下数据。select s.id,s.name,srt.typeId, stt.nam.. 阅读全文