Strange result with this SQL statement...

Hello all,
insert into average_table
select max(id) id, max(custname) custname, '' type, avg(price) price, '' flag from main_table group by id; The average_table has the same column as the main_table. What I want to do is just taking the average of PRICE with each customer, put NULL values into column TYPE and FLAG. However, I find that the TYPE column are filled with character '1', while FLAG has the NULL values. What are the possible causes that the values of column TYPE are all filled with '1'?
Thanks,
David

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 20 2000 - 00:00:00 CST