0

The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this.

select * from clientcode order by cc_clientcode
result:(5627 row(s) affected)

select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname
,c.Client_panno,c.client_userid
from clientcode cc LEFT outer join client c 
on cc.cc_panno=c.client_panno order by cc_clientcode
Result:(5638 row(s) affected)
1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by nithin.gujjar
0

Thanks all, the problem was client table had multiple rows with with same client_panno that's a logical error.We are not supposed to have it that way.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.