Re: CROSS APPLY alternative in MySQL
Posted by:
Rick James
Date: December 11, 2014 04:51PM
Not pivot, GROUP_CONCAT:
SELECT InvoiceID,
GROUP_CONCAT(ProductName SEPARATOR "; ") AS Product Names
FROM tbl GROUP BY InvoiceID;
Subject
Written By
Posted
December 11, 2014 09:19AM
December 11, 2014 12:08PM
Re: CROSS APPLY alternative in MySQL
December 11, 2014 04:51PM
December 11, 2014 10:47PM
December 12, 2014 02:20AM
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.