Re: Is it possible to do a Distinct on just one Column? (non PK)

2004-04-05 Thread Edson Carlos Ericksson Richter
PROTECTED] Sent: Monday, April 05, 2004 11:49 AM To: OJB Users List Subject: Re: Is it possible to do a Distinct on just one Column? (non PK) AFAIK, you will need a ReportQuery. Richter McCaffrey, John G. wrote: I need to do a query and retrive a filtered set of data. Basically I have a composite

RE: Is it possible to do a Distinct on just one Column? (non PK)

2004-04-05 Thread McCaffrey, John G.
Richter [mailto:[EMAIL PROTECTED] Sent: Monday, April 05, 2004 11:49 AM To: OJB Users List Subject: Re: Is it possible to do a Distinct on just one Column? (non PK) AFAIK, you will need a ReportQuery. Richter McCaffrey, John G. wrote: >I need to do a query and retrive a filtered set of d

Re: Is it possible to do a Distinct on just one Column? (non PK)

2004-04-05 Thread Edson Carlos Ericksson Richter
AFAIK, you will need a ReportQuery. Richter McCaffrey, John G. wrote: I need to do a query and retrive a filtered set of data. Basically I have a composite primary key item_code Price_Area_code price_bracket_cd effect_date an item can be in multiple price_areas , and will have historical entries