Skip to Content

Obtain a list from an object on a different table

Feb 09, 2017 at 10:05 PM


avatar image
Former Member


I'm working on a report that is using two different queries. I want to compare the names from one table (let's say table A) to the list of names on another table (let's say table B).

I tried using a variable something like =[a].[name] in list([b].[name]) but is not working. I researched why and found out that I need to merge the tables. I did but I see that the merge produced an inner join rather than full join. If I have an inner join then, it does not make sense to compare. I need either a full, left or right join to know where a <>b and b<> a. I really want to know how can I obtain a list out of an object. so I can compare both tables.

I'm using the desktop rich client (without patches).


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Feb 10, 2017 at 11:31 AM
10 |10000 characters needed characters left characters exceeded