ParentFull threadrpz·Kdb has foreign key equi-joins built in just like you mention. You can see how it looks under the notes section here https://kparc.com/d.txtView on HN