Member Avatar for nithin.gujjar

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
  • 97 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by nithin.gujjar
Member Avatar for nithin.gujjar

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.