in z_messages, lets say MsgID of 1,2,3,4,5

and in z_replymessages, has ParentMsgID of 1,2,3,3,3,3,4

MsgID is equal to ParentMsgID (is related)

CANT GET IT..
==============

SELECT z_messages.MsgID,z_messages.MsgTrash1,z_messages.MsgTrash2 FROM z_messages
JOIN z_replymessages ON z_messages.MsgID = z_replymessages.ParentMsgID
WHERE z_messages.UserID = 2 AND z_messages.MsgTrash1 = 'NO' OR z_messages.SenderID = 2 AND z_messages.MsgTrash2 = 'NO';

SELECT z_messages.MsgID,z_messages.MsgTrash1,z_messages.MsgTrash2 FROM z_messages
RIGHT JOIN z_replymessages ON z_messages.MsgID = z_replymessages.ParentMsgID
WHERE z_messages.UserID = 2 AND z_messages.MsgTrash1 = 'NO' OR z_messages.SenderID = 2 AND z_messages.MsgTrash2 = 'NO';

SELECT z_messages.MsgID,z_messages.MsgTrash1,z_messages.MsgTrash2 FROM z_messages
LEFT JOIN z_replymessages ON z_messages.MsgID = z_replymessages.ParentMsgID
WHERE z_messages.UserID = 2 AND z_messages.MsgTrash1 = 'NO' OR z_messages.SenderID = 2 AND z_messages.MsgTrash2 = 'NO';

============

now, i test those code above.. non is working...
i want to query without doubles...

coz when i query, MsgID 3 will repeat 4 times... how do i remove duplicate in mysql statement? please help..