Complicated mysql query

[vedro-compota]

Hi guys !
Please help make a sql-query -
There are three tables -

table STUDENT
(
  STUDENT_ID NUMERIC not null,
  SURNAME    VARCHAR(60),
);
table SUBJECT
(
  SUBJ_ID   NUMERIC not null,
  SUBJ_NAME VARCHAR(100),
);
 table EXAM_MARKS
(
  EXAM_ID    NUMERIC not null,
  STUDENT_ID NUMERIC not null,
  SUBJ_ID    NUMERIC not null,
  MARK       NUMERIC
);

please tell me - which sql-query is needed to get a list of students who receive a positive assessment in all subjects?
Can I do this job without subqueries?
Thanks in advance!

[jlego]

SELECT

STUDENT.SURNAME

FROM

EXAM_MARKS

INNER JOIN STUDENT ON

EXAM_MARKS.STUDENT_ID = STUDENT.STUDENT_ID

WHERE

MARK > whatevernumberyouwantitobegreaterthan

[jeremy24]

Excellent post.. Thanks for sharing this complicated query..

[vedro-compota]

jeremy24 - Chill, dude )))))))))))));)

[vedro-compota]

thank you jlego !

[jlego]

your welcome please mark as solved

[vedro-compota]

yes of course) +toyou)