minus is not working
prakashMar 29 2011 — edited Mar 29 2011Hi all,
can any one tell me how minus works.
(SELECT edi_trnsctn_type_name, meta_data_cid, meta_data_name, clm_source_code,
document_level_qlfr, target_column
FROM temp_tdc)
minus
(SELECT edi_trnsctn_type_name, meta_data_cid, meta_data_name, clm_source_code,
document_level_qlfr, target_column
FROM temp_midev);
first query return 425 rows
second query returns 421 rows
If i execute the above query it has to give four rows ,but it is giving 296 rows please help me.
I should find those 4 rows .
thank you
Regards,
P Prakash