Use SQL CROSS JOIN instead of old style joins

Also clarifies the SQL SELECT construction/execution expression rewriting.