Learn More
Resend Email
7
randomr
7y

So back to the stories of the gentleman with his master's degree who's job I wasn't qualified for. Hope you all enjoy this gem I found in his stored procedure.

Select distinct *
From(
Select * from a inner join b on a.id=b.id
Union
Select * from a full join b on a.id=b.id
Where b.id is null
)

An inner join unioned to a full join where you exclude null values in right table creates a.....left join you fucking idiot!

undefined

sql
Favorite
Ranter
Comments
  • 1
    7y
    You need a master's degree for SQL?
  • 0
    7y
    @mightyleguan he was hired as an advanced data analyst. Works for a department that distributes dashboards and bi related tools to end users, mainly management.
  • 1
    7y
    @randomr oh, ok
  • 0
    7y
    Doesn't it include null values of right table? So it would be right join?
  • 0
    7y
    @sSam nope. Left join is all records in left table and any that match b table. When you do a full join and include where b is null you eliminate all records where a and b match as well as all rows that have b and not an a. This leaves you with all of the a table that doesn't have match in b table.
    The top innerjoin gives you the ones that match. Combine the data sets with union and you have a left join.
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment