PDA

View Full Version : how to get the unmatched records from DataTable1 by comparing DataTable2 in Oracle



anbu.gn
31 Mar 2011, 5:51 AM
Dear All,

I want to get the unmatched records from DataTable1 by comparing DataTable2

eg :

Table 1

CallId Destination Call type

1 15515643 MOSE

2 16464996 MOSE

3 46169789 MOSTT

4 48892269 MOSTT


Table 2

CallId Destination Call type

1 15515643 Local

4 48892269 STD


I want to match the above two table by using column "CallId" and I want the result as Below

(Unmatched records of Table 1)

CallId Destination Call type

2 16464996 MOSE

3 46169789 MOSTT


How can I achive this by using LINQ ?????????


Please Help......

azuroff
31 Mar 2011, 7:42 AM
As this is neither an Oracle nor LINQ forum, you're probably in the wrong place...