SELECT     TOP (100) PERCENT 'Purchasing' AS projectName, dbo.VERSION.FileName, dbo.VERSION.Keywords, dbo.VERSION.Subject, dbo.VERSION.Document_No, 
                      dbo.ACL.Name AS ACLName, dbo.FRP_TABLE.Description AS ACLDesc, dbo.SECURITY.Name AS SecLvl, dbo.VERSION.FileName AS Null_0, 
                      'L:\' + dbo.VERSION.FileName AS fileSee, 'L:\' + dbo.VERSION.FileName AS Existed, dbo.FILES.Prefix_ID, dbo.FILES.File_No
FROM         dbo.VERSION INNER JOIN
                      dbo.FRP_TABLE ON dbo.VERSION.FRP_ID = dbo.FRP_TABLE.FRP_ID INNER JOIN
                      dbo.FILES ON dbo.FRP_TABLE.FRP_ID = dbo.FILES.FRP_ID INNER JOIN
                      dbo.ACL ON dbo.VERSION.ACL_ID = dbo.ACL.ACL_ID AND dbo.FILES.ACL_ID = dbo.ACL.ACL_ID INNER JOIN
                      dbo.SECURITY ON dbo.VERSION.Security_ID = dbo.SECURITY.Security_ID AND dbo.FILES.Security_ID = dbo.SECURITY.Security_ID
WHERE     (dbo.FILES.Prefix_ID = 8) AND (dbo.FILES.File_No = '0100-02-01')