/****** Script for SelectTopNRows command from SSMS ******/ SELECT * FROM T_Call_OutAnswers ans join T_Ask_Question que on ans.F_QID=que.F_QuestionId where 1=1 and que.F_Type=3 --and F_QID in (select F_QuestionId from T_Ask_Question where F_Type=3 ) order by F_OptOn desc