SQL Code Help!! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Code Help!!

Author

Topic

isjord
Starting Member

38 Posts

Posted - 2006-01-21 : 15:26:14

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '{'.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ')'.

What does this mean?

This is what I am trying to do.

Which students are enrolled in Database (Introduction to Relational Databases) and Networking? (Hint: Use the SECTION_ID for each class so you can determine the answer from the IS_REGISTERED table by itself.)

Student_ID Student_Name
38214 Letersky
54907 Altvater
66324 Aiken
70542 Marra

STUDENT (Student_ID, Student_Name)

Faculty_ID Faculty_Name
2143 Birkin
3467 Berndt
4756 Collins

FACULTY (Faculty_ID, Faculty_Name)

Student_ID Section_ID Semester
38214 2714 I-2001
54907 2714 I-2001
54907 2715 I-2001
66324 2713 I-2001

IS_REGISTERED (Student_ID, Section_ID, Semester)

Course_ID Course_Name
ISM 3113 Syst Analysis
ISM 3112 Syst Design
ISM 4212 Database
ISM 4930 Networking

COURSE (Course_ID, Course_Name)

Section_ID Course_ID
2712 ISM 3113
2713 ISM 3113
2714 ISM 4212
2715 ISM 4930

SECTION (Section_ID, Course_ID)

Faculty_ID Course_ID Date_Qualified
2143 ISM 3112 9/1988
2143 ISM 3113 9/1988
3467 ISM 4212 9/1995
3467 ISM 4930 9/1996
4756 ISM 3113 9/1991
4756 ISM 3112 9/1991

IS_QUALIFIED (Faculty_ID, Course_ID, Date_Qualified)

This is what I did and got the error message at the top. What did I do wrong?

Select * FROM Student WHERE Student_ID IN{
Select Student_ID FROM Is_Registered WHERE Section_ID IN(
Select Section_ID FROM Section WHERE Course_ID IN(
Select Course_ID FROM Course WHERE Course_ID LIKE '964212')))
AND Student_ID IN(
Select Student_ID FROM Is_Registered WHERE Section_ID IN(
Select Section_ID FROM Section WHERE Course_ID IN(
Select Course_ID FROM Course WHERE Course_ID LIKE '964930')))

albanie

jbkayne
Posting Yak Master

100 Posts

Posted - 2006-01-21 : 15:43:07

The error is a result of a bad character in your sql query. I've bolded it below. You should also strongly consider rewriting your query using inner joins.

Select * FROM Student WHERE Student_ID IN{
Select Student_ID FROM Is_Registered WHERE Section_ID IN(
Select Section_ID FROM Section WHERE Course_ID IN(
Select Course_ID FROM Course WHERE Course_ID LIKE '964212')))
AND Student_ID IN(
Select Student_ID FROM Is_Registered WHERE Section_ID IN(
Select Section_ID FROM Section WHERE Course_ID IN(
Select Course_ID FROM Course WHERE Course_ID LIKE '964930')))

isjord
Starting Member

38 Posts

Posted - 2006-01-21 : 16:11:03

How do you do that?

albanie

jbkayne
Posting Yak Master

100 Posts

Posted - 2006-01-21 : 16:22:42

I'd suggest using Books Online. It comes with SQL Server and has SYNTAX examples.

This is untested, but should be close to getting you what you want.

Select
s.Student_Name
from
STUDENT as s
inner join IS_REGISTERED as i
on s.Student_ID = i.Student_ID
inner join SECTION as sc
on sc.Section_ID = i.Section_ID
inner join COURSE as c
on c.Course_ID = sc.Course_ID
where
c.Course_Name in ('Database','Networking')

isjord
Starting Member

38 Posts

Posted - 2006-01-21 : 17:03:22

Which instructors can teach only one of the courses Syst Analysis and Syst Design?

Student_ID Student_Name
38214 Letersky
54907 Altvater
66324 Aiken
70542 Marra

STUDENT (Student_ID, Student_Name)

Faculty_ID Faculty_Name
2143 Birkin
3467 Berndt
4756 Collins

FACULTY (Faculty_ID, Faculty_Name)

Student_ID Section_ID Semester
38214 2714 I-2001
54907 2714 I-2001
54907 2715 I-2001
66324 2713 I-2001

IS_REGISTERED (Student_ID, Section_ID, Semester)

Course_ID Course_Name
ISM 3113 Syst Analysis
ISM 3112 Syst Design
ISM 4212 Database
ISM 4930 Networking

COURSE (Course_ID, Course_Name)

Section_ID Course_ID
2712 ISM 3113
2713 ISM 3113
2714 ISM 4212
2715 ISM 4930

SECTION (Section_ID, Course_ID)

Faculty_ID Course_ID Date_Qualified
2143 ISM 3112 9/1988
2143 ISM 3113 9/1988
3467 ISM 4212 9/1995
3467 ISM 4930 9/1996
4756 ISM 3113 9/1991
4756 ISM 3112 9/1991

IS_QUALIFIED (Faculty_ID, Course_ID, Date_Qualified)

albanie

mr_mist
Grunnio

1870 Posts

Posted - 2006-01-23 : 04:22:43

You know, you really should do your own homework.

-------
Moo. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources