Minus in Teradata?...

Minus : It will provide the result which one is not matching from both tables...

Note: It will provide the not matching result from first select table only.

Select Emp_No from

Emp

Minus

Select Emp_no from

Emp_Dep;