Write a SQL query to extract specific patient records while maintaining data integrity across three joined tables.
