SQL Question / PERF Names

Hello Everyone,

I am new to TESS and trying to write a query that will join from the T_ORDER to the actual performance description. I can get from the order table (T_ORDER) to the performance (T_PERF) but cannot find if there is another table that will get me to the performance name description,

So instead of linking to a performance number it I could export with the show name eg "Harry Potter" as it would appear on the front end,

or here 'description' in the client,

Many Thanks,

Matt