On Sun, Dec 26, 2021, at 19:54, Sascha Kuhl wrote: > Could you make > > JOIN key ?
Not sure what you mean. Perhaps you can explain by rewriting the normal query below according to your idea? SELECT * FROM permission p LEFT JOIN role r ON p.role_id = r.id Given the foreign key on "permission" that references "role" is named "permission_role_id_fkey". /Joel