I would consider myself a SQL query hacker. Trying to come up with a query that shows a list of edrawing markup files (serialized file naming with MRK- as the prefix) in a vault and the original solidworks file I linked to it via a Paste as Reference. Here is what I have so far:
select Documents.Filename as 'Markup File', XRefs.XRefDocument as 'Original Document'
join XRefs on Documents.DocumentID=XRefs.DocumentID
where Filename like 'MRK-%' and Deleted=0
My results show:
|Markup File||Original Document|
|MRK-000792 - Increase radii to 30 mm.eprt||4678|
I would like to see the file name instead of document id in the second column. Any thoughts on how to do that?