Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2011-02-15 : 09:07:11
|
I keep getting join types confused......I have two tables (1) claimline and (2) claimheader. Claimline has claim line level detail to my claims and could have multiple records that match claimheader. Can anyone please help me to understand why when I do an inner join (ClaimLine CL inner join ClaimHeader CH) or a left join (ClaimLine CL leftjoin ClaimHeader CH) I get the same record count?Thanks  |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-15 : 09:37:15
|
| May be because you have 1 or more rows in both the tables so all the matching records are appearing.To see the difference, keep record only in one table and no matching records in other table.Ex: Insert a record in ClaimHeader only |
 |
|
|
mikgri
Starting Member
39 Posts |
|
|
|
|
|
Joins