[ 1
FROM customer c JOIN customer_transaction ct ON c.Customer_SSN_ID = ct.Customer_ID WHERE c.Customer_SSN_ID = 1; -- Specify the Customer ID to check details
]1