CREATE TABLE Customers (customer_id VARCHAR, customer_first_name VARCHAR)
CREATE TABLE Accounts (account_id VARCHAR, date_account_opened VARCHAR, account_name VARCHAR, other_account_details VARCHAR, customer_id VARCHAR)

Show the id, the account name, and other account details for all accounts by the customer with first name 'Meaghan'.
SELECT T1.account_id, T1.date_account_opened, T1.account_name, T1.other_account_details FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.customer_first_name = 'Meaghan'
SELECT "T1"."account_id", "T1"."date_account_opened", "T1"."account_name", "T1"."other_account_details" FROM "Accounts" AS "T1" JOIN "Customers" AS "T2" ON "T1"."customer_id" = "T2"."customer_id" AND "T2"."customer_first_name" = 'Meaghan'