Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Steven Buehler (steveibushost.com)
Date: Sat Aug 16 2008 - 08:52:02 CDT
I have a query that I just can't seem to get working.
insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id) (select
from team_season where team_id=s1.div_id) from scheduler s1);
Of course, I am getting the dreaded "Unknown column 's1.div_id' in 'where
clause'" error message.
I think the statement above shows what I am trying to do better than me
explaining it. My only real problem is that the div_id needs to be gotten
from the team_season table.
Any help would be appreciated