>SELECT Mails.mailkey, .F. AS sel, Mails.readmail, Catmst.cat_name,; > <b>PADR(IIF(Mails.imp=1,"HIGH",IIF(Mails.imp=2,"NORMAL","LOW")), 6)</b> AS priority,; > Addbook.sender, Mails.subject, Mails.recvdt, Mails.docdt,; > Addbook.designation, Mails.action, Mails.proposalno, Mails.fileno,; > Mails.rcvlink, Mails.remark, Med04.language, Statumst.status,; > Mediumst.medium, Mails.user, Mails.maildate; > FROM amw!mails, amw!addbook, amw!catmst, med04, amw!statumst, amw!mediumst; > WHERE Catmst.cat_code = Mails.cat_code; > AND Addbook.sendercode = Mails.sendercode; > AND Med04.lang = Mails.lang; > AND Statumst.statuscode = Mails.statuscode; > AND Mediumst.mediumcode = Mails.mediumcode; > AND Mails.user = ?MUser; > ORDER BY Mails.maildate DESC