DEV Community

Discussion on: Conditional Column Join in SQL

Collapse
 
seimic profile image
seimic

you can have it shorter too

nvl(table1.letter, table2.letter) = table2.letter

Collapse
 
gschro profile image
gschro

That's much more succinct! Thanks for sharing!