1 min
Updated: Aug 16, 2020
QuickBytes is a series of articles for simple and easy to implement techniques with exponential benefits
In the previous article and video, we have seen how we can use the Merge Queries feature to join two different tables. This QuickBytes article covers how we can use Merge Queries for doing self-join. We perform self-join where we need inputs from the same table.
Consider the following example:
Objective: Add a column for Manager ID
Select the same table in Merge Query:
Expand table and select ID