Simple SQL Question
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
Subject
Written By
Posted
Simple SQL Question
August 26, 2017 11:56PM
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.