Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Unless you outer join, in which case NULL values pop up out of thin air...


Good point. I did try to say that whether that's a viable technique would depend on your query (but omitted some verb that should have made it better resemble a sentence in English :)).

But yes, even if no nulls are present in any table, outer join could (or maybe even should) introduce them.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: