04 Oct 19 · npack ·       Add to Favorites  

Snowflake Left outer join syntax

Example:1

SELECT R.* FROM Roster R
LEFT JOIN PlayerStats P
ON R.LastName = P.LastName;

Example:2

select t1.col1, t2.col1 from t1 
left outer join t2 on t2.col1 = t1.col1 
order by 1,2;

npack

posted on 04 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied