asked on
select tblcategory.catnameeng CateNameEng, down1.catnameeng Sub1, down2.catnameeng sub2
from TblCategory
left outer join TblCategory as down1 on TblCategory.CatID=down1.MainID
left outer join TblCategory as down2 on down1.catid=down2.mainid
where TblCategory.MainID='0' and TblCategory.CatID >'0'