Please give syntax of scalar subquery to join three tables

Analytics
Enthusiast

Please give syntax of scalar subquery to join three tables

Please give syntax of scalar subquery to join three tables

regards,-mack

Tags (1)
2 REPLIES
Enthusiast

Re: Please give syntax of scalar subquery to join three tables

As you haven't mentioned the table names or columns to join them, I have put generic query below. You can change it as per your requirements. Also, not sure why you want to use scalar subquery instead of outer joins.

SELECT t1.one

,(SELECT t2.two FROM TEST2 t2 WHERE t1.one=t2.two) t21

,(SELECT t3.three FROM TEST3 t3 WHERE t1.one=t3.three) t31

FROM TEST1 t1

Enthusiast

Re: Please give syntax of scalar subquery to join three tables

Thank you very much ks42982,

Regards,

-mack