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 '%34%' AND yaxley.TubeList LIKE '%38%' AND yaxley.Num = '4' ) 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 '%34%' AND combinedtable.TubeList LIKE '%38%' AND combinedtable.Num = '4' ) 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 '%34%' AND redbook.TubeList LIKE '%38%' AND redbook.Num = '4' )
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 |
|---|---|---|---|---|---|---|---|
| Delco | 6010 | 4 | 1D6, 34, 1B5, 38 | Y | |||
| Electrical Research Laboratories, Inc. | Erla, Sentinel | 34B | 4 | 1C6, 34, 1B5, 38 | Y | ||
| Federated Purchasers, Inc. | Acratone | 167B, 167D | 4 | 1B5/25S, 1C6, 34, 38 | 5DF | S | |
| Federated Purchasers, Inc. | Acratone | 168B, 168D | 4 | 1B5/25S, 1C6, 34, 38 | S | ||
| Gamble Skogmo, Inc. | Coronado | 34B, 34BT | 4 | 1B5/25S, 1C6, 34, 38 | S | ||
| Gamble Skogmo, Inc. | Coronado | 34BT | 4 | 1C6, 34, 1B5, 38 | Y | ||
| Parker McCrory | 5DB (775,001 and up) | 4 | 1C6, 34, 1B5, 38 | Y | |||
| Sentinel | See United Air Cleaner Corp | 34B | 4 | 1C6, 34, 1B5, 38 | Y | ||
| Setchell Carlson, Inc. | Setchell Carlson | 40 | 4 | 1A6, 34, 38, 75 | S | ||
| Simplex Radio Company | Simplex | DB, DF (775,001 and up) | 4 | 1C6, 34, 1B5, 38 | Y | ||
| Walgreen | 34B | 4 | 1C6, 34, 1B5, 38 | Y | |||
| Zephyr Radio Company | Zephyr | DB, DF | 4 | 1C6, 34, 1B5, 38 | Y |