SELECT T1.name FROM camera_lens AS T1 JOIN photos AS T2 ON T2.camera_lens_id  =  T1.id WHERE T1.brand  =  'Sigma' OR T1.brand  =  'Olympus'
What are the names of photos taken with the lens brand 'Sigma' or 'Olympus'?
SELECT T1.name FROM camera_lens AS T1 JOIN photos AS T2 ON T2.camera_lens_id = T1.id WHERE T1.brand = 'Sigma ' OR T1.brand = 'Olympus '
select t1 . name from camera_lens as t1 join photos as t2 on t2 . camera_lens_id = t1 . id where t1 . brand = value or t1 . brand = value
What are the names of photos taken with the lens brand 'Sigma ' or 'Olympus ' ?