Left join issue

[Anonymous]

Hello,

I have some issues in joining two tables. I have the TENANT table which has all tenants information and UNITS table which has all buildings units information. I need to join these two tables in order to create some analysis. The problem is that I have some vacant units with no tenants, thus they do not exist in TENANT table but they exist in UNITS table. Therefore, I create a left join so I keep the vacant units in my joined table.

The totals of the table are correct but the vacant units do not appear in the joinned table.

Can you please give some ideas why this is happening?

Many thanks,

Marios 

[gooranga1]

hi @Anonymous

I presume you are using the "Merge Queries" drop down on manage queries?

If you are did you execute the merge with UNITS as the top query and TENANT as the bottom query in the Merge dialogue when you specified Left Outer (all from first,matching from second)?

[Anonymous]

Hello gooranga,

Many thanks for your prompt response. Yes first was the UNITS and second was the TENANTS as I need to keep all the information from units table.

Best regards,

Marios

[gooranga1]

I just did a quick test and I can merge the tables keeping all the units? is that hpw you merged your tables?