例如:
select a.id,a.date from CMS_Data a join CMS_Column_Rel_Product b on a.colproID=b.idjoin CMS_Menu c on b.menu_num=c.menu_numleft join CMS_Address d on b.area_num=d.idwhere b.menu_num=1 and a.Disabled=0