MySQL Forums
Forum List  »  Newbie

Help on queries
Posted by: serge pecher
Date: August 03, 2015 09:14AM

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

Options: ReplyQuote


Subject
Written By
Posted
Help on queries
August 03, 2015 09:14AM
August 03, 2015 09:20AM
August 03, 2015 09:42AM
August 03, 2015 10:02AM


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.