A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ProviderCats.CatId = providers.CatId and location2.id = providers.location2' at line 1

select providers.providerName,ProviderCats.catType,location2.location,ProviderCats.keywords,ProviderCats.metadesc from providers,ProviderCats,location2 where providers.id = and ProviderCats.CatId = providers.CatId and location2.id = providers.location2