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 primary key by Table2
Thanks!
Tatjana
______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
