لأننا نؤمن ان الإنسان يستحق فرصة ثانية

Select *, (Select Subcategory1_Name From Sub_Category1 Where Sub_Category1.Subcategory1_ID=Products.Subcategory1_ID) Subcategory1_Name, ROW_NUMBER() OVER(Order By RSP) AS RowNumber From Products Where Stock > 0 And Active='True' And Status='Approved' And Year(Cr_Date)=Year(GetDate())