Notes on Joins and Other stuff.