Select *,
(Select Main_Category_Name From Main_Category Where Main_Category.Main_Category_ID=Sub_Category1.Main_Category_ID) As Main_Category_Name,
(Select Main_Category_NameAr From Main_Category Where Main_Category.Main_Category_ID=Sub_Category1.Main_Category_ID) As Main_Category_NameAr
From Sub_Category1 Where Subcategory1_ID='men-hand-bags' Or Replace(LTrim(RTrim(Subcategory1_Name)), '& ', '')='men hand bags'