Absolutely nothing is wrong. The join is doing exactly what you are telling it to do.

Please take a look at the link in mine, and Drew's signature that describes how to properly post code.

None of what you are posting makes sense, nor does it match.

But, based on what you posted, you are joining on "account" and "cid". I'm guessing, and it certainly is a guess, that there are far more records with matching values for these fields.

You gave us these queries:

select all_ID,My_Name,account,total,total_split,money_no from misc where all_ID=5505

select cid,all_ID,number from method where all_ID=5505

You need to run this query:

select all_ID,My_Name,account,total,total_split,money_no from misc where account = 'A55'

select cid,all_ID,number from method where CID = 'A55'

I bet that these return a lot more rows.

Like I said in my first post, look at your join condition.