| Query type | Query criteria | Query statement |
| Full join query | No condition setting | Select location ID, install location, acquisition time, temperature, humidity, sampling batch, sampling information From production process, monitoring of quality parameter, monitoring environment Where production process. Location ID = monitoring of quality parameter. Location ID = monitoring environment. Location ID | Location condition join | Monitoring location as query condition | Select location ID, install location, acquisition time, temperature, humidity, sampling batch, sampling information From production process, monitoring of quality parameter, monitoring environment Where production process. Location ID = monitoring of quality parameter. Location ID = monitoring environment. Location ID and location ID between[ID1,IDn] | Time condition join | Time as query condition | Select location ID, install location, acquisition time, temperature, humidity, sampling batch, sampling information From production process, monitoring of quality parameter, monitoring environment Where production process. Location ID = monitoring of quality parameter. Location ID = monitoring environment. Location ID and collection time between[T1,Tn] |
|
|