Re: [SQL] Add calculated fields from one table to other table

On 10/25/06, roopa perumalraja <[EMAIL PROTECTED]> wrote: Hi   I have two tables. Tick table has fields like ticker, time, price & volume and Timeseries table has fields like ticker, time, avg_price, avg_volume.   The time field in Timeseries table is different from time in tick table, its the

[SQL] Add calculated fields from one table to other table

Hi   I have two tables. Tick table has fields like ticker, time, price & volume and Timeseries table has fields like ticker, time, avg_price, avg_volume.   The time field in Timeseries table is different from time in tick table, its the timeseries for every minute. Now I want to calculate the a