If I do an equivalent query in Oracle, I get a result like-
Product Cost
------- ----
p1 10
p1 10
p1 20
But,in BO, the records returned are-
Product Cost
------- ----
p1 10 (only one of these is returned)
p1 20
The properties are set to return duplicate records. Where did I mess?
Product Cost
------- ----
p1 10
p1 10
p1 20
But,in BO, the records returned are-
Product Cost
------- ----
p1 10 (only one of these is returned)
p1 20
The properties are set to return duplicate records. Where did I mess?