create table new as
select * from one where
connect not in (select distinct connect from two);
This generates a sub query to find all the values of connect in two. The where clause will take only the records from one which do not have a value of connect that is in the list resulting from the sub query.