<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma><FONT size=2>Khalid Baheyeldin<SPAN
class=014500802-05092009> wrote:</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=014500802-05092009>> This is
plain SQL, and hence there is nothing stopping you from using DISTINCT as well
as ORDER BY, like any other SQL.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=014500802-05092009>> It
should be portable between MySQL and PostgreSQL.</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=014500802-05092009></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=014500802-05092009>Thank you,
Khalid. It looked like it, but this is the first time in this territory, so I
wasn't sure. I did that and it worked great.<BR></DIV></SPAN></FONT></FONT>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" color=#ff00ff size=4>Nancy E. Wichmann,
PMP</FONT></DIV>
<DIV align=left><FONT face="Courier New"><FONT size=2>Injustice anywhere is a
threat to justice everywhere. -- Dr. Martin L. King, Jr<SPAN
class=014500802-05092009>.</SPAN></FONT></FONT></DIV></BODY></HTML>