>>select k_prempl, k_prdedmst >> from c_PenDetail pd >> WHERE NOT EXISTS ( SELECT * FROM prdedemp >> WHERE k_prdedmst = pd.k_prdedmst AND k_prempl = pd.k_prempl) >> >>* or >>select pd.k_prempl, pd.k_prdedmst >> from c_PenDetail pd >> LEFT JOIN prdedemp pr ON pr.k_prdedmst = pd.k_prdedmst AND pr.k_prempl = pd.k_prempl >> WHERE pr.k_prdedmst IS NULL >> >>