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 '%6B7%' AND yaxley.TubeList LIKE '%42%' AND yaxley.TubeList LIKE '%76%' AND yaxley.TubeList LIKE '%6D6%' AND yaxley.Num = '7' ) 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 '%6B7%' AND combinedtable.TubeList LIKE '%42%' AND combinedtable.TubeList LIKE '%76%' AND combinedtable.TubeList LIKE '%6D6%' AND combinedtable.Num = '7' ) 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 '%6B7%' AND redbook.TubeList LIKE '%42%' AND redbook.TubeList LIKE '%76%' AND redbook.TubeList LIKE '%6D6%' AND redbook.Num = '7' )
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 |
---|---|---|---|---|---|---|---|
Belmont Radio Corporation | Belmont | 755 | 7 | 6B7, 6C6, 2-6D6, 42, 76, 80 | S | ||
Belmont Radio Corporation | Belmont | 755EX | 7 | 6D6, 6C6, 76, 6B7, 42, 80 | Y | ||
Belmont Radio Corporation | Belmont | 777 Series B | 7 | 2-6D6, 6C6, 76, 6B7, 42, 80 | Y | ||
Case Electric Corporation | Case | 710, 713 714, 715, 716, 718, 719 | 7 | 6K7, 6L7, 6D6, 6B7, 42, 76, 80 | Y | ||
Case Electric Corporation | Case | 710, 713, 714, 715, 716, 718, 719 | 7 | 6B7, 6D6, 6K7, 6L7, 42, 76, 80 | S | ||
Crosley Radio Corporation | Crosley | 715 (Corsair) | 7 | 6D6, 6A7, 6B7, 2-76, 42, 80 | Y | ||
Crosley Radio Corporation | Crosley | 715, 725 | 7 | 6A7, 6B7, 6D6, 42, 2-76, 80 | S | ||
Crosley Radio Corporation | Crosley | 725 | 7 | 6D6, 6A7, 6B7, 2-76, 42, 80 | Y | ||
Gamble Skogmo, Inc. | Coronado | 512 | 7 | 6B7, 3-6D6, 42, 76, 80 | S | ||
Gamble Skogmo, Inc. | Coronado | 574 | 7 | 6B7, 3-6D6, 42, 76, 80 | S | ||
Gamble Skogmo, Inc. | Coronado | 777C and 777L, Series B | 7 | 2-6D6, 6C6, 76, 6B7, 42, 80 | Y | ||
Gamble Skogmo, Inc. | Coronado | 777C, 777 Series B | 7 | 6B7, 6C6, 2-6D6, 42, 76, 80 | S | ||
Gamble Skogmo, Inc. | Coronado | 7J-512, 574 | 7 | 6B7, 3-6D6, 42, 76, 80 | S | ||
Gamble Skogmo, Inc. | Coronado | 7J512, 77574 | 7 | 2-6D6, 76, 6B7, 42, 80 | Y | ||
Goodyear Tire & Rubber Company, Inc. | Goodyear, Wings | 777 series B | 7 | 2-6D6, 6C6, 76, 6B7, 42, 80 | Y | ||
Montgomery Ward And Company | Airline | 123 | 7 | 6B7, 3-6D6, 42, 76, 80 | S | ||
Montgomery Ward And Company | Airline | 123 (Series 7D) | 7 | 2-6D6, 6B7, 76, 42, 80 | Y | ||
Montgomery Ward And Company | Airline | 131 (7D), 133 (7D), 142(7D), 144(7D) | 7 | 2-6D6, 6B7, 76, 42, 80 | Y | ||
Montgomery Ward And Company | Airline | 142, 144, 132, 133 | 7 | 6B7, 3-6D6, 42, 76, 80 | S | ||
Montgomery Ward And Company | Airline | 152 | 7 | 6B7, 3-6D6, 42, 76, 80 | S |
Next | Last |