MYSQL Query in PHP
I have 3 tables
Each asset can have monitoring setup and each monitoring type can have protocols setup.
I need to select all the assets that have monitoring setup of type 'calibration' and also that have protocols setup for the monitoring type.
Asset is linked to monitoring by 'asset_id'
Monitoring is linked to protocols by 'monitor_id'
I have attached a diagram of my tables that might help.DB Tables.jpg
I think I need to build the query using joins but I am not sure where to even start.
Any help or suggestions would be great.