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.

The aforementioned code is a basic search engine that is capable of searching multiple columns in all rows in a mySQL databse, but as it stands the code is not very useful. It's recommended to use ...