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 [EMAIL PROTECTED] | Telephone: (503) 222.2783
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
