CREATE TABLE Accounts (statement_id VARCHAR, account_details VARCHAR)
CREATE TABLE Statements (statement_details VARCHAR, statement_id VARCHAR)

Show statement id, statement detail, account detail for accounts.
SELECT T1.statement_id, T2.statement_details, T1.account_details FROM Accounts AS T1 JOIN Statements AS T2 ON T1.statement_id = T2.statement_id
SELECT "T1"."statement_id", "T2"."statement_details", "T1"."account_details" FROM "Accounts" AS "T1" JOIN "Statements" AS "T2" ON "T1"."statement_id" = "T2"."statement_id"