getMessageInboxList

SELECT A.message_inbox_id,A.subject,A.content,
        A.receipient_id, B.fullname AS receipient_name, A.sender_id,
        C.fullname AS sender_name, A.flg_starred, A.flg_read,
        A.flg_delete, A.create_datetime, A.create_user_id, A.update_datetime,
        A.update_user_id, A.version, A.flg_cc,A.original_to, A.original_cc
    FROM m_message_inbox A
    INNER JOIN t_user B ON A.receipient_id = B.user_id
    INNER JOIN t_user C ON A.sender_id = C.user_id
    WHERE true ;