MYSQL Inner join for three to four tables -

please need figure out doing wrong. created inner join code mysql. works gives me repeated values repeating particular row twice or categoryid twice. each of tables(users,paymentnotification,monthlyreturns) has categoryid used check , display username(users.pname) user table, check , display have made payment monthly returns , payment table using categoryid.

$r="select monthlyreturns.categoryid, monthlyreturns.month, monthlyreturns.quarter, monthlyreturns.year,paymentnotification.amount, users.pname, monthlyreturns.ototal, paymentnotification.payee, status paymentnotification  inner join (monthlyreturns inner join users on monthlyreturns.categoryid=users.categoryid)  on monthlyreturns.categoryid=paymentnotification.categoryid  order monthlyreturns.categoryid desc"; 

i think query want more this:

select b.categoryid, b.month, b.quarter, b.year, a.amount, c.pname, b.ototal, a.payee, status paymentnotification inner join monthlyreturns b    on a.categoryid = b.categoryid inner join users c    on b.categoryid = c.categoryid order b.categoryid desc 

the way doing correlations doesn't seem clear , may cause problems. try 1 out , see happens. if still doing duplicates, perhaps nature of data require further filtering.