MySQL Forums
Forum List  »  Newbie

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

Hi,

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:
patent_id
patent_attribute1
patent_attribute2
patent_attribute3


assignee table:
patent_id
assignee_id

Thank You,
Nick

Options: ReplyQuote


Subject
Written By
Posted
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, only registered users may post in this forum.

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.