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(at)commandprompt(dot)com | Telephone: (503) 222.2783