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 '%7w7%' AND yaxley.TubeList LIKE '%fm100%' ) 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 '%7w7%' AND combinedtable.TubeList LIKE '%fm100%' ) 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 '%7w7%' AND redbook.TubeList LIKE '%fm100%' )
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 |
---|---|---|---|---|---|---|---|
Philco Radio & Television Corporation | Philco, Transitone | 46-1213 | 11 | 7W7, 7F8, 2-7H7, 7B7, 6SQ7, 7AF7, FM1000, 2-6V6, 5U4 | |||
Philco Radio & Television Corporation | Philco, Transitone | 46-1213 | 11 | 7W7, 7F8, 2-7H7, 7B7, 6SQ7, 7AF7, FM1000, 2-6V6, 5U4 | R | ||
Philco Radio & Television Corporation | Philco, Transitone | 48-482 | 9 | 7W7, 7F8, 2-7H7, 7B7, FM1000, 7B6/6SQ7, 6V6, 5Y3 | R | ||
Philco Radio & Television Corporation | Philco, Transitone | 48-482 | 9 | 7W7, 7F8, 2-7H7, 7B7, FM1000, 7B6/6SQ7, 6V6, 5Y3 |