select * from xxminus select * from yy it will pick up all different records. it is usefull when compare 2 result set to find the differences.