Загрузка данных


SELECT wells.id_well, wells.number_well, clusters.id_clusters, type_well.name_type_well, oil_fields.name_oil_field FROM wells JOIN clusters ON wells.id_cluster = clusters.id_clusters JOIN oil_fields ON clusters.id_oil_fields = oil_fields.id_field JOIN type_well ON wells.id_type_well = type_well.id_type_well LEFT JOIN repair ON wells.id_well = repair.id_well WHERE repair.id_well IS NULL