Pulling data from different tables to generate a report

[MEC]

Hi

I’m trying to generate a report which will have values from different tables with same reference Id. The key in my “Client” table is the reference in all other tables like “Client profile”,“Spouse”, “Employment” table and etc. I have successfully pulled the data from my “Client profile” table with the help of @tsuji_koichi but I don’t know how to pull the other data from other tables. I’m currently working on pulling the data from my “Employment” table but an error occurs.

Here’s the error

Any help would be appreciated!

Thanks!