Q:

SQL Finding information about Person in two rows

I have to following Database called Data1
DateOfBooking | Short   |  Long  |  TimeOfBooking  | ID
-------------------------------------------------------
14.06.2016    | KAL     |  blabla| 13:02           | 1
14.06.2016    | DEF     |  del   | 14:02           | 3
14.06.2016    | KAL     |  blabla| 17:34           | 2
14.06.2016    | DOL     |  blub  | 13:02           | 1

I want to to find the ID of the person were KAL at 13:02 and DOL at 13:02 where booked but only if both were booked (at the same time).
KAL and DOL are always booked at the same TimeOfBooking for one ID but I can't figure out how to get the result.
I tried 
SELECT DISTINCT Data1.ID
FROM Data1
WHERE (((Data1.Short = 'KAL') AND (Data1.Long Like 'blabla')) 
AND ((((Data1.Short = 'DOL') AND (Data1.Long Like 'blub')))
Group BY Data1.ID

Of course this did not work as it only looks into one row. Is there a way to look into both rows and find the corresponding ID?
Thank you. 

A:

Not quite sure what you're asking, but this will return the data when a KOL and a DOL have same id and timestamp:
select tk.*, td.*
from (select * from data1 where Short = 'KAL') tk
join (select * from data1 where Short = 'DOL') td
  ON tk.id = td.id and tk.TimeOfBooking = td.TimeOfBooking

