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

Legend

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