Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Left join issue

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 tabl...
Need Help
gooranga1's avatar
gooranga1
Power Participant
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    gooranga1
    Power Participant
    8 years ago

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