水平地连接两个MySQL查询。保持所有柱的完整

Question

SELECT * 
FROM Under_200 u
WHERE u.Chance_of_Gain_under > 75;


SELECT * 
FROM Over_200 o
WHERE o.Chance_of_Gain_over > 75;

我试图以横向的方式连接两个单独的MySQL查询。例如Pandas连接在轴= 1的地方。

Answer 1

如果符号是列分母，则可以使用位查询作为子查询。

SELECT u.*,o.*
FROM
(SELECT * 
FROM Under_200 
WHERE Chance_of_Gain_under > 75) u
JOIN
(
SELECT * 
FROM Over_200 
WHERE Chance_of_Gain_over > 75)  o ON o.Symbol = u.Symbol

Answer 2

WITH custom_tab1
         AS (SELECT *
             FROM   under_200
             WHERE  chance_of_gain_under > 75),
         custom_tab2
         AS (SELECT *
             FROM   over_200
             WHERE  chance_of_gain_over > 75)
    SELECT *
    FROM   custom_tab1 ct1
           INNER JOIN custom_tab2 ct2
                   ON ct1.symbol = ct2.symbol; 

看看这个有用不管用。我使用一个常见的表表达式进行了求解。