Strange SQL Generation SQL Server XIr2 Migrated Universes

[system]

I believe this is related to the issue posted yesterday:

120×120 10.4 KB

XI R2 Designer, Oracle 9i RDBMS We have two tables: customers and orders, with cardinalities set to indicate a customer places many orders. We have an Order Type object using orders.order_type as the select, and Number of Unique Customers using select(distinct customers.cust_id) as the object select. In the Designer Query Panel, DeskI and WebI, when a query is defined with Number of Unique customers as a result object and Order Type = ‘ABC’ as a condition, it throws an “Incompatible combinati…

Trying changing the cardinalities all to 1 to 1, and I bet the SQL generated is much better - without having to include the condition as a result.

---

JMCabot (BOB member since 2005-12-21)