There was an error, please try agains. select Rate.* from Rate,_Rate where _Rate.ID='' AND _Rate.RateID=Rate.RateID ORDER BY _Rate.SortOrder