Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014

    Unanswered: How To Concatenate Both Table

    May I know that how can I concatenate both table in order to display the result:
    Employee and Title(as shown in attachment 1)

    select last_name, job_id
    from employees

    will produce the result as shown in attachment 2. what I need to do is to make it displayed like result in attachment 1.
    Thanks for your guides!
    Attached Thumbnails Attached Thumbnails 1.JPG   2.JPG  

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    If you want both columns presented as a single column, then you need to use an expression to make them into a single column.
    SELECT last_name || ', ' || job_id
       FROM employees;
    Note that it is a better idea to do this in the presentation layer than in the database layer of your application.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts