about joins

i keep referring to this often. do read the comments part in which a reader explains the limitations.

http://www.codinghorror.com/blog/archives/000976.html