1 2 3 4 5
| SELECT PARTS.PartNumber, PARTS.VersionNumber, SERIAL_NUMBER.SerialNumber AS SerialNumber_BatchNumber, SERIAL_NUMBER_AIRCRAFT_PARTS.Status, SERIAL_NUMBER_AIRCRAFT_PARTS.Current_location, PARTS.Storage_location_number,ESSAI_SN.IDaircraft
FROM ESSAI_SN INNER JOIN (SERIAL_NUMBER RIGHT JOIN (PARTS INNER JOIN SERIAL_NUMBER_AIRCRAFT_PARTS ON PARTS.IDparts = SERIAL_NUMBER_AIRCRAFT_PARTS.IDparts) ON SERIAL_NUMBER.IDserial_number = SERIAL_NUMBER_AIRCRAFT_PARTS.IDserial_number) ON ESSAI_SN.PartNumber=PARTS.IDparts
UNION SELECT PARTS.PartNumber, PARTS.VersionNumber, BATCH_NUMBER.BatchNumber, BATCH_NUMBER_AIRCRAFT_PARTS.Status, BATCH_NUMBER_AIRCRAFT_PARTS.Current_location, PARTS.Storage_location_number,ESSAI_BN.IDaircraft
FROM ESSAI_SN INNER JOIN (PARTS RIGHT JOIN (BATCH_NUMBER INNER JOIN BATCH_NUMBER_AIRCRAFT_PARTS ON BATCH_NUMBER.IDbatch_number = BATCH_NUMBER_AIRCRAFT_PARTS.IDbatch_number) ON PARTS.IDparts = BATCH_NUMBER_AIRCRAFT_PARTS.IDpart) ON ESSAI_BN.PartNumber=PARTS.IDparts; |
Partager