Select Top 1000000 tblComputers.Computer, tblComputers.Username, tblDiskdrives.Caption, tblDiskdrives.Description, tblDiskdrives.Size, tblDiskdrives.Volumeserialnumber, tblDiskdrives.Lastchanged, tblDiskdrives.Freespace, tblDiskdrives.FileSystem, tblDiskdrives.Volumename From tblComputers Inner Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Where tblDiskdrives.Description Like 'Removable Disk' And tblDiskdrives.Freespace > 1