Unnamed

select * from (select abssolutionid,count(abssolutionid) as numcomponentsinsoln  from abstractcomponent ac1 inner join abssolutionabscomponent asac on ac1.id = asac.abscompidwhere	(		ac1.inchistring = 'H2O' or		((ac1.inchistring is null or ac1.inchistring = '') and ac1.name = 'Water')	) 	or	(		ac1.inchistring = 'KCl' or		((ac1.inchistring is null or ac1.inchistring = '') and ac1.name = 'Potassium Chloride')	)group by abssolutionid) as solutionswithany where numcomponentsinsoln = 2;