Joins & Windows Functions

Them that are joined together thou shall not put asunder!! not even through an analysis of windows function. I actually don't know why this phrase keeps popping up in my head whenever i think of this topic, well let me indulge you; i will give you a very simple illustration of joins in a marriage set-up this will remain etched in your brains forever. To understand JOINS Think of two families and their relation, in two tables Table 1 The Bride Table; bride_id bride_name 1 Mary 2 Anna 3 Grace Table 2 The Grooms Table; groom_id bride_id groom_name 10 1 John 11 2 Peter We will use a join to connect this two tables using the bride_id as the Connecting Factor. Thus A join is used to connect two tables in a scenario where the two tables have a related column. Let me share another simple example to make understanding even more easier. say you have; Table 1 with the following columns and rows; |student_id| name| |0001| Mary| |0002| John| Table 2 | name| age| | Mary | 39 | | john| 42 | These two