Re: trouble with join

2002-04-13 Thread Christopher Thompson
On Saturday 13 April 2002 4:34 pm, Samwise Gamgee wrote: > I am trying to update a table with information from that same table and > another table. I have two tables, player and goalie, for a hockey pool. > The field pool_points is total points for forwards, goals * 2 for > defencemen and point

trouble with join

2002-04-13 Thread Samwise Gamgee
I am trying to update a table with information from that same table and another table. I have two tables, player and goalie, for a hockey pool. The field pool_points is total points for forwards, goals * 2 for defencemen and point + wins * 2 + ties + shutouts * 5. The goalie table is separa