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, 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.