Searching for chemical structures is a pain. There are nice systems for searching subsets of data:
Scifinder
Beilstein
Your corporate in-house database
Merck Index
Medchem
Prous Ensemble: www.prous.com/databases/ensemble/ensemble.html
But there is no way to perform substructure searches across them or to join results