Category "junction-table"

Using SQL to join tables with a junction table

I am trying to output data from 2 different tables in my database which are joined by a junction table. Table 1: musician Columns: musicianID, surname, fName