Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.:
col_1 + col_2 + col_3 + col_4 ----> col_1 of second table col_5 + col_6 + col_7 + col_8 ----> col_2 of second table col_9 + col_10 + col_11 + col_12 ----> col_3 of second table .... ..... In Oracle I could create a view from the initial table, what about MySQL? Do I really have to loop through each row to build the second table? Thanks in advance --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php