| From: | "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Create View |
| Date: | 2003-10-15 01:01:42 |
| Message-ID: | 009401c392b7$e5fefe30$1f00a8c0@middinkcomp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Dear all,
I Have This table
Table Billing:
id trx_date trx_time depart payment_method billing_amount amount_paid balance creator
1 10/09/2003 21:55:02 Resto Visa 13.800,00 10.000,00 3.800,00 middink
Table Payment
id r trx_date trx_time descriptions payment_method amount creator
1 10/08/2003 18:17:40 Payment Cash 2.000,00 middink
I would like to create "View " from above table with result look like:
trx_date trx_time descriptions payment_method debet credit balance creator
10/09/2003 21:55:02 Resto Billing 13.800,00 Paid: 10.000,00 Visa 3.800,00 3.800,00 middink
10/08/2003 18:17:40 Payment Cash 2.000,00 1.800,00 middink
How can I create View like above?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aicean | 2003-10-15 02:09:11 | How can I produce the following desired result? |
| Previous Message | Sean Chittenden | 2003-10-14 19:14:04 | Re: How to determine the current user |