Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
|
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. [code=sql]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 …
|