多表联查+去重,咋办?
那就先分别去重,再用分别去重之后的表进行联查。
要查一个表里status='published'的,另一个表里的apk包名,想到了这样。
select core_item.id,core_item.title,capp.apkfile from core_item,(select item_id,apkfile from core_app where id in (select max(id) from core_app group by item_id) order by item_id) as capp where capp.item_id=core_item.id and core_item.state='published'