.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

how to retrive non matchin records from oracle table?

Posted By: Dhivakaran     Posted Date: November 22, 2010    Points:2   Category :Sql Server
I m having below structured two tables

table1 name - trans_log
Trans_id,
Msisdn,
keyword,
event

table2 name - recon_log
Trans_id,
Msisdn,
keyword,
event

Trans_id and msisdn both having same value in both table but keyword and event having different values in both table for same records. that records i need to get . please help me how to get



Responses
Author: Sadhuryan             
Posted Date: November 22, 2010     Points: 5   

Dhivakaran, Hope this will help you

select T1.Trans_id, T2.Trans_id, T1.Msisdn, T2.Msisdn, T1.keyword, T2.keyword, T1.event, T2.event from trans_log T1, recon_log T2 where T1.Trans_id = T2.Trans_id and T1.Msisdn = T2.Msisdn and (T1.keyword <> T2.keyword or T1.event <> T2.event)



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend