02-queries/acc_stm_union.sql

select  'ACCT' as Col1, Accounts.AccountNumber as Col2,Accounts.ProductCode as Col3,Accounts.AccountStatus as Col4  from Accounts where  AccountNumber='ACCOUNT_G_0006'
union
select  'BILL' as Col1, Statements.AccountNumber as Col2,Statements.DueDateofBill as Col3,Statements.BillGenerationDate as Col4  from Statements where AccountNumber='ACCOUNT_G_0006'