I am studying sql in an autodidactic way, the manager that I am using is phpmyadmin, I am exactly studying the topic of cross-references, as I understand mysql does not support the PIVOT and TRANSFORM commands, does anyone know how I can make a table of Cross-references as close as possible to if you were using PIVOT and TRANSFORM? 