Beth is correct in her statement. I'm sorry if some of my responses to this question are getting cut off but the network people are working on upgrading the email service. listed is my response to tom that was clipped by the email server. —--- Rick, You are correct. Both statements will return the same results. It could be the wrong results depending on the circumstances. Duplicate records will not show up. An ORDER BY is needed for that in this situation. Distinct and group by remove the duplicates.. Ron
>>> [EMAIL PROTECTED] 02/06/02 01:28PM >>> I think he just misread the "group by" as an "order by" trailer infor removed------- Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).