Often, you’ll want to combine certain rows of a table with other rows of the same table, the SQL SELF JOIN will do the job.
