I have a database that contains information about the distance that three objects have travelled. I’m trying to write a query that displays the date and time and distance data for each object.
Object 1 moved at 5 mph for 1 minute. Object 2 moved at 1 mph for 2 minutes. Object 3 moved at 9 mph for 3 minutes. Mph stands for miles per hour.
Here’s my first attempt to write a query. The result contains null values.
SELECT tblTimes.tDate, tblTimes.tTime, tblObjects.Object_1_Speed,
FROM tblTimes INNER JOIN
tblObjects ON tblTimes.TimeID = tblObjects.TimeID INNER JOIN
tblDurations ON tblObjects.DurationID = tblDurations.DurationID
The database backup and query results are attached. Also attached are screen shots of the database diagram and the desired results for the report.
I had to change the extension of the backup file to .txt in order to upload it to EE. Just change the extension back to .bu.
Please help me write a query that does not contain any null values.