Write a SQL query using different types of joins (inner, left, right, full) to combine patient and prescription records.
