audition Details Test SELECT AuditionInfo.Production, AuditionCategory, AuditionInstructions, RehearsalDates, AuditionQuestions, Submissions, AuditionDates, CallBackDates, ProductionNotes, Performances.ShowName, Performances.Company, Performances.Note1, Performances.ShowNote, Performances.Times, Performances.Director, Performances.MusicalDirector, Performances.Choreographer, Performances.Producer from `TestAuditionInfo` INNER JOIN TestPerformances ON AuditionInfo.Production = Performances.Production