whats wrong with this expression??

[dominatrix1]

select students.studentid, students.fname, students.sname, course.courseunitid
from students, course
WHERE course.courseunitid = "1" AND "grade" >75

 

[matja]

"grade" shouldn't be in quotes, and you should probably have a table name prefixed to it, if you're doing a cross-join

 

[Haircut]

"grade" shouldn't be in quotes, and you should probably have a table name prefixed to it, if you're doing a cross-join

And he appears to be doing a cartesian join

 

[matja]

same thing

 

[Haircut]

same thing

Didn't actually see that bit of your post!