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 (companies.Company LIKE '%regal%' OR companies.tradename LIKE '%regal%') ) 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 (companies.Company LIKE '%regal%' OR companies.tradename LIKE '%regal%') ) 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 (companies.Company LIKE '%regal%' OR companies.tradename LIKE '%regal%') )
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 |
---|---|---|---|---|---|---|---|
Regal Electronic Corporation | Tok-Fone | 1049 | 6 | 12SG7/12SH7/14A7, 12SA7/14Q7, 12SK7/14A7, 12SQ7/14B6, 35L6/35A5, 35Z5/35Y4 | |||
Regal Electronic Corporation | Tok-Fone | 1049 | 6 | 12SH7/12SA7/14A7, 12SAG7/14Q7, 12SK7/14A7, 12SQ7/12B6, 35L6/35A5, 35Z5/35Y4 | R | ||
Regal Electronic Corporation | Tok-Fone | 141, 141 S.W. | 4 | 2-6K5, 25L6, 25Z5 | S | ||
Regal Electronic Corporation | Tok-Fone | 142 E.A., 143, 510, 600, 600 E.A | 3 | 6K5, 25L6, 25Z5 | K55H | S | |
Regal Electronic Corporation | Tok-Fone | 144 | 5 | 2-6B5, 6J7, 6N7, 83V | S | ||
Regal Electronic Corporation | Tok-Fone | 1749 | 6 | 12SG7/12SH7/14A7, 12SA7/14Q7, 12SK7/14A7, 12SQ7/14B6, 35L6/35A5, 35Z5/35Y4 | |||
Regal Electronic Corporation | Tok-Fone | 1749 | 6 | 12SG7, 12SA7, 12SK7, 35L6, 35Z5 | R | ||
Regal Electronic Corporation | Tok-Fone | 205 | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | R | ||
Regal Electronic Corporation | Tok-Fone | 205 | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | |||
Regal Electronic Corporation | Tok-Fone | 208 | See Model W-700 | R | |||
Regal Electronic Corporation | Tok-Fone | 747 | 4 | 1R5, 1T4, 1S5, 3S4 | R | ||
Regal Electronic Corporation | Tok-Fone | 747 | 4 | 1R5, 1T4, 1S5, 3S4 | D.R. | ||
Regal Electronic Corporation | Tok-Fone | 762 | 6 | 12SG7/12SH7/14A7, 12SA7/14Q7, 12SK7/14A7, 12SQ7/14B6, 35L6/35A5, 35Z5/35Y4 | |||
Regal Electronic Corporation | Tok-Fone | AP40, ARP400, ARP450 | 4 | 14F7, 2-35A5, 35Y4 | R | ||
Regal Electronic Corporation | Tok-Fone | AP40, ARP400, ARP450 | 4 | 14F7, 2-35L6, 2-35A5, 35Z5/35Y4 | |||
Regal Electronic Corporation | Tok-Fone | Doorphone | 2 | 6C6, 25A7, 90B | S | ||
Regal Electronic Corporation | Tok-Fone | L-46 | 6 | 12SA7, 2-12SK7, 12SQ7, 35L6, 35Z5 | |||
Regal Electronic Corporation | Tok-Fone | L-47 | 6 | 6SA7, 6SK7, 6SF7, 2-25L6, 25Z6 | |||
Regal Electronic Corporation | Tok-Fone | L-76 | 6 | 12SK7/12SJ7, 12SA7, 12SK7, 12SQ7, 35L6/50L6, 35Z5 | R | ||
Regal Electronic Corporation | Tok-Fone | L-76 | 6 | 12SA7, 2-12SK7, 12SQ7, 35L6, 35Z5 |
Next | Last |