/*results.asp case=Country u=*/ SELECT Markers.MarkerID, Marker, Memorial, [The-Prefix] INTO #R8384995Country1727034221 FROM Markers LEFT JOIN Countries ON Markers.Country=Countries.Country WHERE Markers.Country COLLATE Latin1_General_CI_AI ='U.S Virgin Islands' AND Accepted Is Not Null AND Rejected Is Null AND Withdrawn Is Null AND ReplacedByID Is Null