我给你写了一写，你看一下，行不行select *from category cg, commodity cd, photo phwhere cg.categoryid = cd.categoryidand ph.commodityid = cd.commodityidorder by commodityid desc
