Tatjana Cukic <[EMAIL PROTECTED]> wrote on 10/07/2005 06:07:07 AM:
> Hi,
>
> does anybody knows how i can add a new column to
> Table1, where new column is made by substracting Col1
> from table Table1 and Col2 from Table2. Here is the
> synthax:
>
> mysql> alter table Table1 add select(x.Col1-y
Hi,
does anybody knows how i can add a new column to
Table1, where new column is made by substracting Col1
from table Table1 and Col2 from Table2. Here is the
synthax:
mysql> alter table Table1 add select(x.Col1-y.Col2) as
differentika from Table1 x,Table2 y where
x.Col3=y.Col3;
Col3 is a primar
