将多个子查询转换为 on join [英] Convert multiple sub-queries to on join

问题描述

我的 sql 中有多个子查询

I have multiple sub-queries in my sql

SELECT *, 
(SELECT Col1 FROM MYTABLE2 WHERE SAME) AS Col1,
(SELECT Col2 FROM MYTABLE2 WHERE SAME) AS Col2,
(SELECT Col3 FROM MYTABLE2 WHERE SAME) AS Col3,
(SELECT Col4 FROM MYTABLE2 WHERE SAME) AS Col4,
FROM MYTABLE1 WHERE XXX 

如何将其转换为一个 JOIN?子查询相同，只是 Select column-name 不同.

How can I convert this to in one JOIN? Sub Query is same only the Select column-name is different.

推荐答案

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

ON 不必关联两个表
这更像是一个过滤的交叉连接

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

这篇关于将多个子查询转换为 on join的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！