5 Replies Latest reply: Sep 26, 2013 10:30 AM by 917621 RSS

    Query on Addresses


      Hello Experts,


      I have a query

      An employee can have multiple addresses

      How can I write a query to show the address of an employee i.e., address1,address2 in different columns

      Here is some demo data for the format which I was looking for


      employee_name    employee_address1   employee_address2

      X                        No-5,Chennai              No-7,Mumbai

      Y                       No-8,Assam                N0-10,Delhi


      Thanks in advance