re: Conditional Column Join in SQL VIEW POST

FULL DISCUSSION
 

you can have it shorter too

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

 

That's much more succinct! Thanks for sharing!

code of conduct - report abuse