MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create TABLE event(
startDate date,
endDate date,
id int, 
title varchar(25)
  );
create table photo(
  source varchar(25),
  eventID int
  );
insert into event (id, title) values (1, 'event one'),(2,'event two');
insert into photo values('source 1',1);
SELECT 
  event.startDate, 
  event.endDate, 
  event.id, 
  event.title, 
  photo.source, 
  photo.eventId 
FROM event
LEFT JOIN photo 
ON event.id = photo.eventId 
WHERE event.id = 1 or event.id = 2;


startDate
endDate
id
title
source
eventId


null
null
1
event one
source 1
1

null
null
2
event two
null
null


SELECT event.startDate, event.endDate, event.id, event.title, photo.source, photo.eventId FROM event, photo 
WHERE (event.id = 1 AND photo.eventId = 1)
or (event.id = 2 AND photo.eventId = 2);


startDate
endDate
id
title
source
eventId


null
null
1
event one
source 1
1

startDate	endDate	id	title	source	eventId
null	null	1	event one	source 1	1
null	null	2	event two	null	null