I am trying fetch records by join two table in mysql but result is what i want.There are only two record in main table but the query result produng multiple record( repeated) what is wrong in my query kindly help
My main table content is
Produced output is
SELECT t1.txnid,t1.stationeryissueddate,t1.orderdate,t1.purpose as pur1,t1.status,t1.stationerytype,t1.stationeryqtyrqst,t1.stationeryqtyissued,t1.remark,t2.purpose as pur2 from tblstationerystock t1 join tblstationerytype t2 on t1.purpose = t2.purpose where t1.uin=13218 order by t1.status desc