Failed Inner Join Using Custom SQL Follow
I have two databases. Both have Serial Number fields in common. I am attempting to join both databases on this field, using the Multi-Database Joins tab, in the Database Connection Setup.
Unfortunately, one database has duplicate Serial Numbers, which was causing Bartender to hang on the inner join attempt.
The duplicate data problem has been solved by selecting the "Use Custom SQL Statement" checkbox, at the table level (and writing a more complex statement to filter out the duplicates). But when I again attempt to join the two databases, I am now unable to see the necessary field entries from the drop down menu, in the Multi-Join Database tab.
The necessary field entries are visible again, when I uncheck the "Use Custom SQL Statement" checkbox, at the table level. But the Operator and Criteria options provided in the Query tab seem too limited for filtering out duplicates. So it does my situation no good.
Is there a way around this? I do not have authority to make changes to the actual database.
I guess what I'm asking is...can two databases be joined together, when one of them is using a custom SQL statement, instead of an auto-generated query statement?