7 Replies Latest reply: Apr 13, 2018 8:58 AM by Youssef Belloum RSS

    joining two table who have three field in common

    Khouloud Rochd

      Hi I want to join two tables that have three tables in common

      table1:

      Load a, b, c, d, e,f

      from table1;

      and the second table is :

      table2:

      Load a, b, c, , j, l

      from table2;

      to join this two tables based on table1.a=table2.a and table1.b=table2.b and table1.c=table2.c

      should I use simply a join between them like this

      Load a, b, c, d, e,f

      from table1;

      join

      Load a, b, c, , j, l

      from table2;

      or what do you suggest ?