Ella, Try this one: use yourdatasource select mr.renditionnumber from mediamaster mm inner join mediarenditions mr on mm.mediamasterid = mr.mediamasterid where mm.mediamasterid not in (select mediamasterid from mediaxrefs) And yes, we have some orphaned media records laying around! From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel Sent: Monday, May 23, 2016 4:28 PM To: [log in to unmask] Subject: broken media links Has anyone figured out a view, script, report, or query to see only media records where the link has been broken? Ella Rothgangel Acting Head of Registration Saint Louis Art Museum 314.655.5408 To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.