| SELECT t1.col_dt t1_dt, t2.col_dt t2_dt, t1.col_state t1_state, t2.col_state t2_state, t1.col_prime t1_prime, t2.col_prime t2_prime, t1.col_name t1_name, t2.col_name t2_name FROM using_f1 t1 JOIN using_f2 t2 USING(col_state) WHERE t2.col_state LIKE '%N%'; |