The LEFTTAB and RIGHTTAB tables are used to illustrate this type of join: The following example joins the LEFTTAB and RIGHTTAB tables to get the Cartesian product of the two tables. The Cartesian ...

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.