I'm kind a stuck at this query and I need just a bit of suggstion.
I've 3 tables CRM, ESCR and Orchard. All 3 table has exact columns. i need a statment where it result matches to CRM and ESCR but not to Orchard. I'have tried building a temp table and do it works for all except 3-4 records and I can't afford to have them. I know I might not be clear but if it makes any sense eplease help! below is result of 1 table, other two table will have similar result, I just want a logical test when it matches cRM and ESCR but not in orchard
INTERNAL_ID ID USN VERSION
28 f1/28 28 2
29 f1/29 28 3
30 f1/30 28 3