Try this assuming that you have a student_id in regentry:
update regentry
Set curriculum = "21"
Where curriculum = "13" and calendar in ("20030", "20040") and
student_Id in (select student_id from regentry
where curriculum = "13" and calendar = "20020"
and grade = "09")
Hope this helps,
Rosa G. Roberts
"Karen Harker" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/24/2003 11:46 AM
Please respond to list
To: <[EMAIL PROTECTED]>
cc:
Subject: Fwd: sql question?
>>> "Noe Arzate" <[EMAIL PROTECTED]> 7/24/2003 11:22:24 AM >>>
Hey, guys.
Sorry I'm changing the subject a little bit but I am having problems
writing an ISQL statement. The where clause won't do the trick. This
is what I'm trying to do.
Table - regentry
Fields- calendar, grade, and curriculum.
I want to update the curriculum code for students that are enrolled as
9th graders in 2001-2002 school year. Then I need to update 2003 and
2004 school years with curriculum codes as well but they have to be 9th
graders that were enrolled in 2002.
I can do this: update regentry
Set curriculum = "21"
Where curriculum = "13" and calendar = "20020" and
grade = "09"
How can I update the following calendars for "only" students that
enrolled as 9th graders in calendar 20020?
2002 is for students in 2001-2002 year and the 0 is the calendar type.
Any help would be appreciated.
Thank you,
Noe Arzate
Systems Administrator
MPISD
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
