MySQL Query : SELECT COUNT(*) as count FROM (select * from v9_picture as a left join v9_picture_data as b on a.id=b.id WHERE qy='3392' AND catid='70' order by inputtime desc) T MySQL Error : Duplicate column name 'id' MySQL Errno : 1060 Message : Duplicate column name 'id' Need Help?