MySQL Forums
Forum List  »  Newbie

Simple SQL Question
Posted by: Nicholas Taylor
Date: August 26, 2017 11:56PM


I have a simple problem I'm trying to solve. I have two tables, a patents table, and an assignees table joined by the patent id. There are instances where there are multiple assignees for a single patent. I would like for a single record to appear for each patent. Where there are multiple assignees per patent, I would like for them to appear as additional columns (assignee1, assignee2, assignee3, etc). I know there is a way to do this, just not sure how.

patent table:

assignee table:

Thank You,

Options: ReplyQuote

Written By
Simple SQL Question
August 26, 2017 11:56PM
August 27, 2017 08:50AM
August 27, 2017 11:59AM
August 27, 2017 05:00PM
August 27, 2017 06:21PM
August 27, 2017 06:38PM
August 27, 2017 07:14PM
August 27, 2017 08:20PM
September 07, 2017 02:38AM

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.