Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

Queries in merging two tables

Good Day, We need to perform a simple activity where I used outer join and merge . The purpose of merge is to actually unite both the tables to proceed further . Since the entries present in the re...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
5 years ago

@Harsha3

Probably you can try with Outer join, putting ‘1’ for Left and Right Path.

Regards,
Spiro Taleski

  • ptaylor's avatar
    ptaylor
    Employee
    5 years ago

    Don’t use Outer when doing a 1=1 join. Always use Inner. The result will be the same, by definition, but the performance, both memory-wise and time-wise, will be better with Inner. This advice is based on the details of the implementation of each of these joins.

    • Harsha3's avatar
      Harsha3
      New Contributor III
      5 years ago

      Hi Ptylor,

      Thanks for the details it actually worked !.

      Thanks Taleski for the updates.