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 '%2A5%' AND yaxley.TubeList LIKE '%2A6%' AND yaxley.TubeList LIKE '%2A7%' AND yaxley.TubeList LIKE '%58%' AND yaxley.Num = '5' ) 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 '%2A5%' AND combinedtable.TubeList LIKE '%2A6%' AND combinedtable.TubeList LIKE '%2A7%' AND combinedtable.TubeList LIKE '%58%' AND combinedtable.Num = '5' ) 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 '%2A5%' AND redbook.TubeList LIKE '%2A6%' AND redbook.TubeList LIKE '%2A7%' AND redbook.TubeList LIKE '%58%' AND redbook.Num = '5' )
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 | 505 SW | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 145 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 145, 185A | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 185A | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 325 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 475 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 475, 735 | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Atwater Kent Manufacturing Company | Atwater-Kent | 735 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Atwater Kent Manufacturing Company | Atwater-Kent | E145, E145X | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Audiola Radio Company | Audiola | 34-S-5 | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Audiola Radio Company | Audiola | 3485 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Audiola Radio Company | Audiola | 50, 51, 52-53 | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Audiola Radio Company | Audiola | 51, 52 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Audiola Radio Company | Audiola | 53 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Belmont Radio Corporation | Belmont | 550 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Echophone Radio Corp. | Echophone | 119 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Echophone Radio Corp. | Echophone | 119, 124, 126 | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Echophone Radio Corp. | Echophone | 126 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y | ||
Echophone Radio Corp. | Echophone | 143 | 5 | 2A5, 2A6, 2A7, 58, 80 | S | ||
Echophone Radio Corp. | Echophone | 143 | 5 | 2A7, 58, 2A6, 2A5, 80 | Y |
Next | Last |