[Solved] Convert multiple sub-queries to on join [closed]

by 


SELECT MYTABLE1.*, MYTABLE2.*
  FROM MYTABLE1 
  LEFT OUTER JOIN MYTABLE2  
    ON same 
 WHERE XXX

The ON does not have to relate the two tables
This is more like a filtered cross join

1

solved Convert multiple sub-queries to on join [closed]