Provided one-step join queries.
Updated TODO: Referential integrity upon record deletion.