This discussion is archived
5 Replies Latest reply: Sep 26, 2013 8:30 AM by 917621 RSS

Query on Addresses

917621 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points