Hi,

I'm working with a Student Marks database.

I have one table that stores information about the subjects that is unique to each learner, example the serial number of the workbook associated with that subject for that learner and that learner's subject mark, however, all generic data is stored in another table to improve normalisation, eg the subjects name and total score.

I also have a table that stores all the minor results related to the subject such as all the practical points and all the exam points. There is no relation between the two results tables as the software does calculations based on the first table and updates the second table.

I now need a query that can give me the Subject name and mark as well as the exam mark and date.

If anybody thinks they can help out please give it a bash, I'm sure it's possible, just not good enough yet...