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 '%2-6d6%' AND yaxley.TubeList LIKE '%6c6%' AND yaxley.TubeList LIKE '%42%' AND yaxley.TubeList LIKE '%75%' 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 '%2-6d6%' AND combinedtable.TubeList LIKE '%6c6%' AND combinedtable.TubeList LIKE '%42%' AND combinedtable.TubeList LIKE '%75%' 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 '%2-6d6%' AND redbook.TubeList LIKE '%6c6%' AND redbook.TubeList LIKE '%42%' AND redbook.TubeList LIKE '%75%' 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 |
|---|---|---|---|---|---|---|---|
| Allied Radio Corporation | Knight | 666 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Belmont Radio Corporation | Belmont | 670A | 6 | 2-6D6, 6C6, 75, 42, 84 | Y | ||
| Belmont Radio Corporation | Belmont | 670A Auto. | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Gamble Skogmo, Inc. | Coronado | 670A | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Gamble Skogmo, Inc. | Coronado | 670A | 6 | 2-6D6, 6C6, 75, 42, 84 | Y | ||
| Goodyear Tire & Rubber Company, Inc. | Goodyear, Wings | 670A | 6 | 6C6, 2-6D6, 42, 75, 80 | S | ||
| Howard Radio Company | Howard | 670A | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Howard Radio Company | Howard | G26 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Howard Radio Company | Howard | HA1 (670A) | 6 | 6C6, 2-6D6, 75, 42, 84 | Y | ||
| Howard Radio Company | Howard | HAl | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Hudson Motor Car Company | Hudson | 680 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Hudson Terraplane | 680 | 6 | 2-6D6, 6C6, 75, 42, 84 | Y | |||
| Laurehk Radio Manufacturing Co. | Laurehk, Musique | Car'uso AE6 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Montgomery Ward And Company | Airline | 102 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Silver-Marshall Manufacturing Company | Silver-Marshall | Air-Flight 670A | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Sparks-Withington Company | Sparton | 71, 71B | 6 | 6C6, 2-6D6, 42, 75, 80 | S | ||
| Sparks-Withington Company | Sparton | 71, 71B | 6 | 2-6D6, 6C6, 75, 42, 80 | Y | ||
| Spiegel, Incorporated | Aircastle | 660 | 6 | 6C6, 2-6D6, 42, 75, 84/6Z4 | S | ||
| Walgreen | 660 (Early, 2 Types) | 6 | 2-6D6, 6C6, 75, 41/42, 84 | Y | |||
| Warwick Manufacturing Corporation | Warwick | 6 tube Auto | 6 | 2-6D6, 6C6, 75, 42, 84 | Y |
| Next | Last |