Most of the application developers are used to use joins - cross joins, inner and outer joins. All resonate well. However, what if we start speaking about lateral join, anti join, self join, does it still look familiar to you? What if we take a look at the predicate evaluation phases in relation to joins - before, during, and after; especially in case of multi-table joins. Did you know, that you can even use joins to unmask the masked data? Do you understand the difference between the join types available in Db2? These are some of the questions we will be addressing.