How to Create View
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?
Muhyiddin A.M Hayat wrote:
Dear all,
I Have This table
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 middinkHow can I create View like above?
Have you created a SQL statement to get this recordset yet? When you
have your SQL query working the way you want, you just run
CREATE VIEW view_name AS your sql query;
then you can perform a SELECT * FROM view_name;
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
rrussell@commandprompt.com | Telephone: (503) 222.2783