SELECT
A.TextData,A.Duration,
A.SPID,
A.ClientProcessID,
A.IntegerData,
A.EventSequence,
B.tablename
FROM
  (SELECT
  event_text,
  TextData,
  CONVERT(DECIMAL(18,2),
  CONVERT(FLOAT,Duration)/1000000) Duration,
  CPU,
  Reads,
  Writes,
  SPID,
  ClientProcessID,
  IntegerData,
  RowCounts,
  EventSequence,
  CONVERT(VARCHAR(12),StartTime,114)StartTime,
  CONVERT(VARCHAR(12),EndTime,114)EndTime,
  HostName,
  ApplicationName,
  ObjectName
  FROM U9_20160531_0800_1000ms
  LEFT JOIN int_to_event
  ON EventClass=event_code WHERE event_text='SP:StmtCompleted')AS A
  LEFT JOIN 20160531_0800_1000ms_usedtables AS B
  ON A.EventSequence=B.eventsequence ;
SELECT
A.TextData,A.Duration,
A.SPID,
A.ClientProcessID,
A.IntegerData,
A.EventSequence,
B.tablename
FROM
  (SELECT
  event_text,
  TextData,
  CONVERT(DECIMAL(18,2),
  CONVERT(FLOAT,Duration)/1000000) Duration,
  CPU,
  Reads,
  Writes,
  SPID,
  ClientProcessID,
  IntegerData,
  RowCounts,
  EventSequence,
  CONVERT(VARCHAR(12),StartTime,114)StartTime,
  CONVERT(VARCHAR(12),EndTime,114)EndTime,
  HostName,
  ApplicationName,
  ObjectName
  FROM U9_20160531_0800_1000ms
  LEFT JOIN int_to_event
  ON EventClass=event_code WHERE event_text='SP:StmtCompleted')AS A
  LEFT JOIN 20160531_0800_1000ms_usedtables AS B
  ON A.EventSequence=B.eventsequence ;