(SELECT DISTINCT C1.ToLoc, (SELECT ME1.EquipmentNumber FROM MajorEquipment ME1 WHERE C1.ToLoc = ME1.MEId) AS EquipmentNumber FROM MajorEquipment ME1 WHEREC1.FromLoc = (SELECT ME1.MEId FROM MajorEquipment ME1 WHERE ME1.Equi
Driver Installed - Executing Test -- MEIDhex value - Executing Test -- IMEI decimal value - (Testing Wireless 5630 (EVDO-HSPA) Mobile Broadband Mini-Card)
JOIN:LEFT JOIN MajorEquipment ON SupplierInfo.SupplierId = MajorEquipment.MEIdUNIONRIGHT JOIN MajorEquipment ON SupplierInfo.SupplierId = MajorEquipment.MEIdSELECT * FROM SupplierInfo
LEFT JOIN MajorEquipment ON SupplierInfo