CODEWITHSUNDEEP
sqloracle-database
Hannes
Hannes

Reputation: 55

problem with sql syntax

The sql syntax is following:

SELECT y.NAME, y.EMAIL, k.DATE, k.WORK_NR, k.SCORE, k.FILENAME
FROM bas1.students y, bas1.assignments k, bas1.topics a
WHERE y.ID = k.student_id AND k.topic_id = a.id
WHERE a.NAME = 'History';

But I get some errors, any Ideas?

Upvotes: 0

Views: 98

Answers (2)

Ethel Evans
Ethel Evans

Reputation: 755

Don't you need join statements? E.g.,

SELECT y.NAME, y.EMAIL, k.DATE, k.WORK_NR, k.SCORE, k.FILENAME
FROM bas1.students y JOIN bas1.assignments k ON y.ID = k.student_id 
JOIN bas1.topics a ON k.topic_id = a.id
WHERE a.NAME = 'History';

Upvotes: 0

Breezer
Breezer

Reputation: 10490

You're using WHERE twice

SELECT y.NAME, y.EMAIL, k.DATE, k.WORK_NR, k.SCORE, k.FILENAME
FROM bas1.students y, bas1.assignments k, bas1.topics a
WHERE y.ID = k.student_id AND k.topic_id = a.id
AND a.NAME = 'History';

change to this

Upvotes: 8

Related Questions