Forum Discussion
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...
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)?