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 ;