problem with sql syntax

Question

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?

Breezer · Accepted Answer · 2010-11-30 21:46:20Z

8

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

answered Nov 30, 2010 at 21:46

Breezer

10.5k6 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ethel Evans · Accepted Answer · 2010-12-01 02:14:17Z

0

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';

answered Dec 1, 2010 at 2:14

Ethel Evans

7557 silver badges19 bronze badges

Collectives™ on Stack Overflow

problem with sql syntax

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related