Help on queries
Hello,
I wonder how to create a query for following :
I have 2 tables :
Address with by example :
Name cat_id
ABC 860
DEF 100,200,860
GHJ 200
Category with :
cat_id cat name
860 supplier
100 customer
200 friend
The result I would like to have is :
ABC supplier
DEF customer
DEF friend
DEF supplier
GHJ friend
Can someone help me to write a query achieving that ?
thanks
sp
Subject
Written By
Posted
Help on queries
August 03, 2015 09:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.