Thanks
- Original Message -
From: "Adam Nelson" <[EMAIL PROTECTED]>
To: "'Andy Jackman'" <[EMAIL PROTECTED]>; "'MySQL'"
<[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 12:26 AM
Subject: RE: dbase calculations
>
I believe views in Oracle (SQL Server? Sybase?) can do this if you need
it.
> -Original Message-
> From: Andy Jackman [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 12:36 PM
> To: MySQL
> Subject: Re: dbase calculations
>
>
> Kalle,
> The usual way
Kalle,
The usual way to do this is to create the table with the 2 real fields
and then use a query to 'create' the sum field at run time. For example
assume you have this table:
create table my_table (
field_1 int(9),
field_2 int(9)
);
then you can write this query:
SELECT fiel
