Results 1 to 9 of 9
Thread: MYSQL Query in PHP
Nov 22, 2010, 05:17 #1
- Join Date
- Jun 2010
- 0 Post(s)
- 0 Thread(s)
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.