| | 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] |
|
|
