SQL to return data including missing data?

I have an Exam table that consists of three fields, Student, Question
and Answer. Two other tables hold all Students and all Questions but
the Exam table may omit some Candidates or some Questions for a
Candidate. I want to return a record for every combination of Student
and Question. None of my attempts using variations of LEFT JOINS have
worked. Can someone help or tell me it's impossible?

In case the database is relevant, I should add that I have been
experimenting in Access but the final database will be Apache Derby
(IBM Cloudscape). However, now that all databases are free, I'm happy
to change databases for a solution :)
.

Relevant Pages

  • Re: Find a row in a table from a form
    ... info is NOT that a student took an exam (and no, ... same exam multiple times) but WHAT score they had. ... a 1:1 relationship to the licensure or licensure information. ... I agree with Lynn that your database does not seem to be normalized. ...
    (microsoft.public.access.forms)
  • Re: Multiple choice answer tracking and exam tracking
    ... But you do need a related table that gives you a *record* for each question the student attempts, instead of a *field* for each question in one big wide table. ... whether the student gave the correct answer to each question in the exam. ... Allen Browne - Microsoft MVP. ... > intention of the database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiple choice answer tracking and exam tracking
    ... intention of the database. ... particular exam (the actual exam subjects and paper #'s will be separated ... g) attempts by a student an an assessment, when the attempts were received, ... Exam information is the main table and the others are linked to it (via ...
    (microsoft.public.access.modulesdaovba)
  • Re: Increase the Date automatically for each entry in a table
    ... needs to take an exam. ... I will then go back into the database after the ... needs to be 7 days after the Term Start Date (which is located in the Student ... break, Spring break, etc. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Creating many worksheets with text from initial worksheet (and
    ... using the name of my workbook; the name of the worksheet, ... I have it populate a large chart for each ... my question is in three parts: I have a spreadsheet with student ... grade percentage for each exam. ...
    (microsoft.public.excel.programming)
Loading