Thread: How to Create View

How to Create View

From
"Muhyiddin A.M Hayat"
Date:
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?

Re: How to Create View

From
Robby Russell
Date:
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