use case: select hash.sha256, users.directory from hash,users where hash.path=users.directory||'/.somefile';