Hi, I have a data base where the first name and the last name are in different columns. I need them in one column, can I join the information into a column directly from the script?
And I need the information in one column:
First_name & ' ' & Last_Name as Full_name,
Try like this
Load First_name &' '&Last_name as Full_name ,* from tablename;
Hope that helps
Retrieving data ...