Hi,
I have 2 tables - tblObjects and tblInspections
tblObjects has object_id (primary key) and object_name.
tblInspections has inspection_id(INT primary key), inspection_name, inspection_date(Date/Time) and object_id (INT foreign key)
I need to build query to show me all objects that DO NOT have inspections in for example '2021'
I have 2 tables - tblObjects and tblInspections
tblObjects has object_id (primary key) and object_name.
tblInspections has inspection_id(INT primary key), inspection_name, inspection_date(Date/Time) and object_id (INT foreign key)
I need to build query to show me all objects that DO NOT have inspections in for example '2021'