subject:"\[SQL\] Using UPDATE FROM"

Re: [SQL] Using UPDATE FROM

2004-09-10 Thread Tom Lane

Collin Peters <[EMAIL PROTECTED]> writes: > Here is the UPDATE statement: > UPDATE programactivitysets SET repsvalue = reps_actual > FROM workouts w, workoutactivities wa, workoutactivitysets was, > programactivities pa, programactivitysets pas > WHERE wa.workout_id = w.workout_id > AND was.worko

[SQL] Using UPDATE FROM

2004-09-10 Thread Collin Peters

I have a sql query which hits 5 database tables. I'll cut a bit out of the results and just show the important values reps_goal reps_actual repsvalue 10 10 1 33 5 1 10 12 1 10 12 1