SELECT DISTINCT table1.status AS Status
FROM table1
INNER JOIN (
        SELECT DataID, MAX(VersionNum) as mVersion
        FROM table1
        GROUP BY DataID
    ) AS b
    ON table1.DataID = b.DataID
    AND table1.VersionNum = b.mVersion
INNER JOIN table2
    ON table1.table2ID = table2.ID
WHERE table2.field = @parameter

WITH CTE_Versions AS (
      SELECT DataID, MAX(VersionNum) as mVersion
      FROM t1
      GROUP BY DataID
  )
  SELECT DISTINCT t1.status AS Status
  FROM t1
  JOIN CTE_Versions AS b
      ON t1.DataID = b.DataID
      AND t1.VersionNum = b.mVersion
  JOIN table2
      ON t1.table2ID = table2.ID
  WHERE table2.field = @parameter

SELECT DISTINCT t1.status AS Status
  FROM t1 with (nolock)
  JOIN (
          SELECT DataID, MAX(VersionNum) as mVersion
          FROM t1 with (nolock)
          GROUP BY DataID
  ) AS b
      ON t1.DataID = b.DataID
      AND t1.VersionNum = b.mVersion
  JOIN table2 with (nolock)
      ON t1.table2ID = table2.ID
  WHERE table2.field = @parameter

SELECT DISTINCT t1.status AS Status
  FROM t1
  JOIN (
          SELECT DataID, MAX(VersionNum) as mVersion
          FROM t1
          GROUP BY DataID
  ) AS b
      ON  t1.DataID = b.DataID
      AND t1.VersionNum = b.mVersion
  JOIN table2
      ON  t1.table2ID = table2.ID
      AND table2.field = @parameter