Ok i have a small database just about set up. Below are the 2 table that I'm using for the query.
System Details
SRN (ID number)
Field
Field
Risk_Category
Field
Inspection Details
SRN (ID number)
Inspection Date
Field
Field
Field
Field
Ok now what i'm trying to achieve:
I want to select...