SELECT *,permissions_answer_lookup.id as ans_id FROM #Request.prefix_db_lookup#.permissions_questions_lookup JOIN #Request.prefix_db_lookup#.permissions_answer_lookup ON permissions_answer_lookup.question_id = permissions_questions_lookup.id WHERE permissions_questions_lookup.Deleted <> 1 AND permissions_answer_lookup.Deleted <> 1 AND permissions_questions_lookup.page = ORDER BY permissions_questions_lookup.order_id ASC SELECT *,permissions_answer_lookup.id as ans_id FROM #Request.prefix_db_lookup#.permissions_questions_lookup JOIN #Request.prefix_db_lookup#.permissions_answer_lookup ON permissions_answer_lookup.question_id = permissions_questions_lookup.id WHERE permissions_questions_lookup.Deleted <> 1 AND permissions_answer_lookup.Deleted <> 1 AND permissions_questions_lookup.page = ORDER BY permissions_questions_lookup.order_id,permissions_answer_lookup.id ASC SELECT * FROM #Request.prefix_db_lookup#.permissions WHERE Emp_ID = AND Loc_ID = INSERT INTO #Request.prefix_db_lookup#.permissions (Emp_ID,Loc_ID,#questions#) VALUES (#arguments.Emp_ID#,#arguments.Loc_ID#,#answers#)