6 Replies Latest reply: Jul 14, 2016 5:41 AM by Mindaugas Bacius RSS

    Left Join Duplicated Rows

    Vítor Castro

      Hello everyone,

       

      i am having a problem with left join

       

      i have these tables:

       

      table 1

       

      idstateclient
      1416

       

      table 2

       

      idstateclientadmin
      1216Y
      1317Y
      1417Y

       

       

      and i want put that field admin on table 1

       

      so i am doing:

       

      Left Join (table1)

      Load

        id,

        idmin

      Resident table2

      where admin='S';

       

      and the result is:

       

      idstateclientadmin
      1416Y
      1417Y

       

      and i need:

       

      idstateclientadmin
      1416Y

       

       

      Can someone help me?

       

      Greetings

       

      Vítor