Exactly what I stated two or three posts ago. That's why using DISTINCT doesn't work in this case. Sounds like a problem which requires reworking of the DB or a better understanding of the nature of the data and desired outcome.
-dhs At 10:07 AM 12/13/01 -0500, you wrote: >Ok...I spoke with one of our Oracle DBAs. The problem lies in that if you >have a set like this > >1, 2, A, B, C >1, 2, D, E, F >2, 2, A, B, C >2, 3, D, E, F > >and did your select statement which one of the rows would you want. What I >mean is this... > >You have these two rows both with your 1,2 but which of the (A,B,C or D,E,F) >rows would you want returned with the 1,2. If you're using CF I would just >return the recordset straight up and manipulate it with code. > > >1, 2, A, B, C >1, 2, D, E, F ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
