Click here to Skip to main content
15,299,742 members
Home / Discussions / C#
   

C#

 
GeneralRe: finding unmatched record/data in two sql tables Pin
James_201214-May-12 10:00
MemberJames_201214-May-12 10:00 
AnswerRe: finding unmatched record/data in two sql tables Pin
Sentenryu15-May-12 1:31
MemberSentenryu15-May-12 1:31 
GeneralRe: finding unmatched record/data in two sql tables Pin
James_201215-May-12 6:08
MemberJames_201215-May-12 6:08 
GeneralRe: finding unmatched record/data in two sql tables Pin
James_201215-May-12 7:36
MemberJames_201215-May-12 7:36 
GeneralRe: finding unmatched record/data in two sql tables Pin
Sentenryu15-May-12 7:55
MemberSentenryu15-May-12 7:55 
GeneralRe: finding unmatched record/data in two sql tables Pin
James_201215-May-12 9:08
MemberJames_201215-May-12 9:08 
GeneralRe: finding unmatched record/data in two sql tables Pin
ArchimaX16-May-12 4:52
MemberArchimaX16-May-12 4:52 
GeneralRe: finding unmatched record/data in two sql tables Pin
Sentenryu16-May-12 5:55
MemberSentenryu16-May-12 5:55 
the inner join is to take the correspondingly registries, that have the same key, in the "where" is where the actual matching is performed, verifing what fields of the table doesn't match. the id must always match, else, how do you know what transaction corresponds to what?

in your query you take the registries that don't have pair in the other table, what the op seems do seek is the registries that have pair, but with different values.
I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)

Answer[Solved] C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Matt U.14-May-12 5:37
MemberMatt U.14-May-12 5:37 
AnswerRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Pete O'Hanlon14-May-12 6:12
mvaPete O'Hanlon14-May-12 6:12 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Matt U.14-May-12 6:54
MemberMatt U.14-May-12 6:54 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Pete O'Hanlon14-May-12 7:18
mvaPete O'Hanlon14-May-12 7:18 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Matt U.14-May-12 7:21
MemberMatt U.14-May-12 7:21 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Matt U.14-May-12 7:24
MemberMatt U.14-May-12 7:24 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Pete O'Hanlon14-May-12 8:32
mvaPete O'Hanlon14-May-12 8:32 
GeneralRe: C#/WinForms :: Hosting A Design Surface and IDesignerEventService Pin
Matt U.14-May-12 8:39
MemberMatt U.14-May-12 8:39 
Questionusing log4net with custom database logger Pin
SASS_Shooter14-May-12 5:08
MemberSASS_Shooter14-May-12 5:08 
Questioncall a jar file from .net clr Pin
nextaxtion13-May-12 21:40
Membernextaxtion13-May-12 21:40 
AnswerRe: call a jar file from .net clr Pin
Pete O'Hanlon14-May-12 1:09
mvaPete O'Hanlon14-May-12 1:09 
GeneralRe: call a jar file from .net clr Pin
Peter_in_278014-May-12 1:19
professionalPeter_in_278014-May-12 1:19 
GeneralRe: call a jar file from .net clr Pin
Pete O'Hanlon14-May-12 1:43
mvaPete O'Hanlon14-May-12 1:43 
Questionhow can i run ~~~.aspx page without popup in c#? Pin
buffering8313-May-12 21:33
Memberbuffering8313-May-12 21:33 
AnswerRe: how can i run ~~~.aspx page without popup in c#? Pin
Nitin S14-May-12 1:28
professionalNitin S14-May-12 1:28 
GeneralRe: how can i run ~~~.aspx page without popup in c#? Pin
Sentenryu14-May-12 2:49
MemberSentenryu14-May-12 2:49 
GeneralRe: how can i run ~~~.aspx page without popup in c#? Pin
buffering8314-May-12 13:33
Memberbuffering8314-May-12 13:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.