create table Testbooks (
  book_id number,
  book_name varchar2(30),
  preis number,
  logis number
  );

  insert into Testbooks (book_id, book_name, preis, logis) values (45, 'Oracle Tools', 80, 2);
  insert into Testbooks (book_id, book_name, preis, logis) values (50, 'Oracle for Beginners', 120, 5);
  insert into Testbooks (book_id, book_name, preis, logis) values (60, 'Advanced SQL', 50, 2);
  insert into Testbooks (book_id, book_name, preis, logis) values (55, 'Advancd Oracle', 150, 5);
  insert into Testbooks (book_id, book_name, preis, logis) values (35, 'JAVA Beginners', 60, 2);  
  
  commit;

create table logistic (
       logis number,            
       s_loc varchar2(20),
       status varchar2(1)
   );

  insert into logistic (logis, s_loc, status) values (2, 'ABC', 'A');     -- A = Active
  insert into logistic (logis, s_loc, status) values (1, 'MOON', 'I');    -- I = Inactive

commit;

select  Testbooks.logis from Testbooks where exists (select logis from  logistic where status = 'I');