combined query = (SELECT companies.Company AS company2, companies.Tradename AS tradename, yaxley.Num, yaxley.Model AS Model2, yaxley.TubeList, yaxley.Resistor, yaxley.YSLR, yaxley.chassis FROM companies, yaxley WHERE yaxley.Company_ID = companies.Company_ID AND yaxley.TubeList LIKE '%6a7%' AND yaxley.TubeList LIKE '%6k7%' AND yaxley.TubeList LIKE '%6f5%' AND yaxley.TubeList LIKE '%6h6%' AND yaxley.Num = '6' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, combinedtable.Num, combinedtable.Model AS Model2, combinedtable.TubeList, combinedtable.Resistor, combinedtable.YSLR, combinedtable.chassis FROM companies, combinedtable WHERE combinedtable.Company_ID = companies.Company_ID AND combinedtable.YSLR LIKE 'S' AND combinedtable.TubeList LIKE '%6a7%' AND combinedtable.TubeList LIKE '%6k7%' AND combinedtable.TubeList LIKE '%6f5%' AND combinedtable.TubeList LIKE '%6h6%' AND combinedtable.Num = '6' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, redbook.Num, redbook.Model AS Model2, redbook.TubeList, redbook.Resistor, redbook.YSLR, redbook.chassis FROM companies, redbook WHERE redbook.Company_ID = companies.Company_ID AND redbook.TubeList LIKE '%6a7%' AND redbook.TubeList LIKE '%6k7%' AND redbook.TubeList LIKE '%6f5%' AND redbook.TubeList LIKE '%6h6%' AND redbook.Num = '6' )
Type in any known information. At least one field needs to be entered or nothing will be shown.
Additional instructions and background info can be found here.
Company | Tradename | Model | Chassis | # Tubes | Tube List | Ballast | Database |
---|---|---|---|---|---|---|---|
Garod Radio Corporation | Garod | 31, 31LW | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
Garod Radio Corporation | Garod | 33, 33LW (Rev.) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
General Electric Company | General Electric | FDE62 | 6 | 6A7, 6F5, 6H6, 6K7, 25Z5, 43 | S | ||
General Electric Company | General Electric | FE-62, FE-67, FE-68 | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | R | ||
General Electric Company | General Electric | FE62 | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | ||
General Electric Company | General Electric | FE62, 62S, 67, 68 | 6 | 6A7, 6F5, 6H6, 6K7, 42, 80 | S | ||
General Electric Company | General Electric | FE67, FE68 | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | ||
Lafayette Radio Corporation | Lafayette | C79, C80 | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
R.P.C. (Radio Products Corporation) | L2 | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | |||
R.P.C. (Radio Products Corporation) | L266 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | |||
R.P.C. (Radio Products Corporation) | ML156, ML215A, ML266, ML366 | 6 | 6A7, 6F5, 6f6, 6H6, 6K7, 80 | S | |||
Radolek Company | 10943, 10944, 10946 | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | |||
Radolek Company | BF10943, 10944, 10946 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | |||
Trav-Ler Radio & Telev. Corporation | Trav-Ler | 63A | 6 | 6A8, 6K7, 6H6, 6F5, 6F6, 5Z4 or 6A7, 6D6, 75, 42, 80 | Y | ||
Westinghouse Electric Supply Company | Westinghouse | WR101 (U6F) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y |
First | Previous |