4 Replies Latest reply: Dec 20, 2013 6:23 AM by Stefan Wühl RSS

    Line duplication SQL Select

    Vincent Mecrin


      Hello,

       

      I'm extracting a table from SQL and the generated table has duplicated lines. The SQL table has no duplicated lines.

      I only running the following script, no table before or after and no join just the database connection before.

       

      Item:

      LOAD *;

      SQL SELECT *

      From MDTestDatabase.SAP.ViewItem;

       

      if i use a ditinct, i have the following results:

      - LOAD Distinct *: no duplication

      - SQL SELECT Distinct *: duplications

       

      So, duplication is generated by LOAD statement and not SQL query.

       

      Any idea?

       

      Thks