Spaces:
Sleeping
Sleeping
File size: 355 Bytes
04c0718 |
1 2 3 |
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' |