I have 3 tables
  1. asset
  2. monitoring
  3. protocols

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.