Multiple same table
This is a multiple same table example. It provide functionality to display multiple same table using alias name. In this example I need to display two categories tables so I define the alias those are first_categories and second_categories. In real world scenario maybe you want to display most popular posts and most commented posts from posts table.