Re: select from two tables then create a new table

* zhu xiaofeng > Sent: Thursday, October 09, 2003 4:45 AM An old question, but no replies... > There is a question: > Two tables: >table_out: ( fields ) product_name,out_count , out_date >table_in: ( fields ) product_name,in_count , in_date > I want to create

select from two tables then create a new table

Hi all: There is a question: Two tables: table_out: ( fields ) product_name,out_count , out_date table_in: ( fields ) product_name,in_count , in_date I want to create a table that show the remain of product. Can you help me?? thanks in advance! -- MySQL G