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 '%6A7%' AND yaxley.TubeList LIKE '%25Z5%' AND yaxley.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') 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 '%6A7%' AND combinedtable.TubeList LIKE '%25Z5%' AND combinedtable.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') 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 '%6A7%' AND redbook.TubeList LIKE '%25Z5%' AND redbook.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') AND redbook.Num = '5' )