nborshukov
New Member
GUI
DB Server: 8.2a
Client: 9.0a
OS: WinXP
I have a problem with execution of browser's query with left outer-join. Here is the open query statement:
define buffer PrevOrder for Order.
open query br-1 for each customer no-lock,
last order where Order.Cust-Num = Customer.Cust-Num,
last PrevOrder left outer-join where PrevOrder.Cust-Num = Order.Cust-Num and
PrevOrder.order-date < Order.order-date
by Customer.Name.
Display fields:
customer.name
order.Order-date
PrevOrder.Order-date
This query must display all the customers, which have AT LEAST one order, and the previous order of the cistomer.
But in fact it displays ALL the cistomers, even they have no orders.
Does anybody knows where is the problem???
By the way, client 9.1d works correctly...
DB Server: 8.2a
Client: 9.0a
OS: WinXP
I have a problem with execution of browser's query with left outer-join. Here is the open query statement:
define buffer PrevOrder for Order.
open query br-1 for each customer no-lock,
last order where Order.Cust-Num = Customer.Cust-Num,
last PrevOrder left outer-join where PrevOrder.Cust-Num = Order.Cust-Num and
PrevOrder.order-date < Order.order-date
by Customer.Name.
Display fields:
customer.name
order.Order-date
PrevOrder.Order-date
This query must display all the customers, which have AT LEAST one order, and the previous order of the cistomer.
But in fact it displays ALL the cistomers, even they have no orders.
Does anybody knows where is the problem???
By the way, client 9.1d works correctly...