Relational shell programming
<i>join</i> is also worth mentioning: as expected, performs relational join of supplied input, equivalent to SQL's STRAIGHT / LEFT / RIGHT JOIN.<p><a href="http://man.cat-v.org/plan_9/1/join" rel="nofollow">http://man.cat-v.org/plan_9/1/join</a>