L
L
Leader282021-12-24 00:46:22
SQL
Leader28, 2021-12-24 00:46:22

Need help with sql access query, how to make it work?

select Пасажиры.ФИО
  from (select r.ID_пасажира 
          from ПосадочныеМеста r 
      group by r.ID_пасажира having count(distinct r.ID_поезда) = (select count(*) from Направления) 
      ) fullRes
  join Пасажиры on Пасажиры.ID_пасажира = fullRes.ID_пасажира;

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question