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
from clientcode cc LEFT outer join client c 
on cc.cc_panno=c.client_panno order by cc_clientcode
Result:(5638 row(s) affected)

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.