Re: guidance on SQL query
> return a few fields from the match table,
> along with an array of the team members
> from the two teams playing in the match.
That query pattern is known as a crosstab or pivot table queru. For various models wih examples see that topic at
https://www.artfulsoftware.com/queries.php
Subject
Written By
Posted
Re: guidance on SQL query
August 10, 2022 04:22AM
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.