SELECT B.bname,J.* FROM Brands B,JeffStore J WHERE J.bid=B.bid AND J.isactive=1 
				ORDER BY B.bname,J.model;