Is it possible to compare a table on 1 database with two tables on another db in the same project?

Jlew

So, comparing table A on db1 with table B and Table C on db2 in the same project

Alex B

Hi @Jlew,

If table B and C each have different columns that are in table A, then you should be able to make a view in db2 with the columns from them that you can then compare with table A. 

However if B and C are both the same and the same as A then you would need to have two separate projects A->B and A->C.

Kind regards,
Alex

Jlew

Thanks @Alex B,

It's the first scenario you described, so it looks like I'll have to create views.
Also good to know about the second scenario.

Thank you for your prompt reply, most helpful,
John