10 Replies Latest reply: Jan 20, 2015 6:51 AM by sai ram RSS

    Two tables with the same column name in my data model

    Wande Sulu

      Hi all,

       

      I have the script below, the problem is both tables (client and contact) have a column called "Surname". The script returns contact.Surname; however, I am interesting in client.Surname. IT is unable to rename the column(s). Can I add a prefix to "surname" to specify that I want client's surname? or what is the best way to approach this problem?

       

      Test:

      LOAD

      Primary_contact,
      Surname,

      SQL SELECT *
      FROM client
      left join contact

      on client_ID = contact_ID

       

      Regards