How can we help you today? How can we help you today?

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

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

Comments

2 comments

Sort by
  • 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
    Alex B
    0
  • 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

    Jlew
    0

Add comment

Please sign in to leave a comment.