Distinctrow not working

[Kelli]

I'm running a query that deteremines what parts need to be
part, by whom and by when

Some parts may be on there twice if it is for two
different work orders. I'm using the distictrow predicate,
but it's still returning duplicate rows

For ex:
Part Release Buyer
123

 

[Kelli]

Sorry didn't finish example...see below

-----Original Message-----
I'm running a query that deteremines what parts need to be
part, by whom and by when

Some parts may be on there twice if it is for two
different work orders. I'm using the distictrow predicate,
but it's still returning duplicate rows

For ex:
Part Release Buyer
123 RABC J Smith
123 RDEF J Smith
123 RDEF J Smith

the 1st and 2nd one ok, but the 3rd one should not show up

 

[Dale Fye]

Try using Distinct instead of DistinctRow. The difference is that
Distinct only returns the Distinct values within the fields that are
enumerated in the SELECT statment, the DistinctRow will include all
the fields to determine what is distinct, not just the fields you are
interested in.

--
HTH

Dale Fye


I'm running a query that deteremines what parts need to be
part, by whom and by when

Some parts may be on there twice if it is for two
different work orders. I'm using the distictrow predicate,
but it's still returning duplicate rows

For ex:
Part Release Buyer
123