select * from C617.ItemData
select * from BRG_Usage_Substitutes

SELECT UsageToPTNs.*, FromThrus.* FROM
BRG_Usage_Substitutes UsageToPTNs, 
(
  Select Distinct Range_ID as RangeID, Low_EFF as FromEff, High_EFF as ThruEff
  from brg_ranges
  Where Low_EFF in
  (
    select cust_variable_id
    from brg_airplanes
    where model_no = '757' and prod_line_no between 1032 and 1074
  )
  Union All
  select Distinct Range_ID as RangeID, Low_EFF as FromEff, High_EFF as ThruEff
  from brg_ranges
  Where High_EFF in
  (
    select cust_variable_id
    from brg_airplanes
    where model_no = '757' and prod_line_no between 1032 and 1074
  )
) FromThrus,
(Select * from BRG_Usage_Ranges where Model_No = '757') RangeToUsage
WHERE FromThrus.RangeID = RangeToUsage.Range_ID
AND RangeToUsage.Usage_Substitute_Instance_ID = UsageToPTNs.Usage_Substitute_Instance_ID