SELECT * FROM #Request.prefix_db_lookup#.hipps_conditions WHERE deleted <> 1 AND scoring_id = SELECT * FROM #Request.prefix_db_lookup#.hipps_code_score WHERE deleted <> 1 ORDER BY order_no SELECT * FROM #Request.prefix_db_lookup#.nrs_points WHERE deleted <> 1 ORDER BY order_no SELECT * FROM #Request.prefix_db_lookup#.nrs_conditions WHERE deleted <> 1 AND nrs_points_id = SELECT * FROM #Request.prefix_db_lookup#.Assessment_Questions_lookup WHERE Assessment_Questions_lookup.assessment_reason = '1 - Start of care - further visits planned' AND Assessment_Questions_lookup.questions like 'M%' GROUP BY Assessment_Questions_lookup.id SELECT * FROM #Request.prefix_db_lookup#.hipps_code_score WHERE id = SELECT * FROM #Request.prefix_db_lookup#.nrs_points WHERE id =