Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi presh,
LOAD
Primary_contact,
Surname,
SQL SELECT Primary_contact, client.Surname
FROM client left join contact on client.client_ID = contact.contact_ID