What I exect is something like

Select record_id

from Security_assignement

Join....

where ........

The the return is

494

Thanks!