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 '%3-78%' AND (companies.Company LIKE '%wil%' OR companies.tradename LIKE '%wil%') ) 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 '%3-78%' AND (companies.Company LIKE '%wil%' OR companies.tradename LIKE '%wil%') ) 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 '%3-78%' AND (companies.Company LIKE '%wil%' OR companies.tradename LIKE '%wil%') )
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 |
---|---|---|---|---|---|---|---|
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 4G7 | 7 | 42, 75, 76, 3-78, 80 | S | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 4G7 | 7 | 42, 75, 76, 3-78, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 4H11 | 11 | 6B7, 4-45, 2-76, 3-78, 80 | S | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 4H11 | 11 | 4-45, 6B7, 2-76, 3-78, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 5E7 | 7 | 76, 3-78, 42, 75, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 5E7, 5EA7 | 7 | 42, 75, 76, 3-78, 80 | S | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 5EA7 | 7 | 76, 3-78, 75, 42, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | 7J7, 7K7 | 7 | 3-78, 6A7, 73, 42, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | A35, A36, A37 | 7 | 3-78, 6A7, 75, 42, 80 | Y | ||
Wilcox.Gay Corporation | Wilcox.Gay, Recordio | A38 | 9 | 6A7, 6F5, 6H6, 42, 77, 3-78, 80 | S |