Struggling with MySQL Queries
I am trying to build a system to keep track of (rail) vehicle maintenance. I have several tables:
tblVehicles - gives details of the individual designation
tblDesignations - gives more detailed information about the vehicle type (not relevant to this)
tblRunningDays - lists the days that each vehicle ran
tblMaintenance - gives details of each inspection due, and when they are carried out.
tblExams - gives details of the type of inspection - some are done based on number of days run, some...
Struggling with MySQL Queries
I am trying to build a system to keep track of (rail) vehicle maintenance. I have several tables:
tblVehicles - gives details of the individual designation
tblDesignations - gives more detailed information about the vehicle type (not relevant to this)
tblRunningDays - lists the days that each vehicle ran
tblMaintenance - gives details of each inspection due, and when they are carried out.
tblExams - gives details of the type of inspection - some are done based on number of days run, some...
Struggling with MySQL Queries