Re: How to Create View

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          middink
>
>
> How 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