Both examples are relevant to both DBs. The first example is what I'm trying to do: combine the contents of two tables using a subquery. This works fine in SQL Server but not in MySQL.

Multiple Field Search With PHP and mySQL. Search engines are integral features to any well designed website, but how well does your search engine work?