Hi,
I have two questions.
1)
How can I realize this query in C-Embedded SQL?
SELECT MAX (score)
FROM report
WHERE uname = 'xxxxxxx'
AND exam_id IN
( SELECT exam_id
FROM exam
WHERE name = 'yyyy'
)
I used DECLARE CURSOR and FETCH for second SELECT statement.
But I don't know how to use WHERE ... IN clause.
2)
I need to create weekly report. I would like to ask users to enter just
one date (for example, Monday of the week).
How can I select information from database for a whole week?
Thank you
-Margarita