-- 2. Multiple-row subqueries: Return multiple rows and are used with operators like IN, ANY, ALL, etc. -- 3. Multiple-column subqueries: Return multiple columns and are typically used in IN or as ...

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.