0
Follow
0
View

oracle horizontal concatenation problem

dulicheng 注册会员
2023-02-27 19:26
SELECT
    a.'维度1',
    a.'维度2',
    a.'应续1',
    a.'应续2',
    b.'已续1',
    b.'已续2' 
FROM
    table_a AS a
    LEFT JOIN table_b AS b ON a.'维度1' = b.'维度1' 
    AND a.'维度2' = b.'维度2'

If it helps, please click to accept ~

About the Author

Question Info

Publish Time
2023-02-27 19:26
Update Time
2023-02-27 19:26