How to define query for multiple tables using diffrent conditions?

[pranita.avhad]

Dear all,

I want to define query fro multiple tables.

Thanks in advance........

 

[rzr]

Could you be more specific ....???

DEFINE QUERY qMyQuery FOR Customer, Order.
 
OPEN QUERY qMyQuery 
         FOR EACH Customer 
             WHERE Customer.Cust-num = 1 NO-LOCK
                EACH Order OF Customer NO-LOCK.
 
REPEAT :
    GET NEXT qMyQuery.
    IF QUERY-OFF-END('qMyQuery') THEN LEAVE.
        DISPLAY Customer.NAME Customer.Cust-num Order.Order-num.
END.
CLOSE QUERY qMyQuery.

 

[MaximMonin]

OPEN QUERY qMyQuery
FOR EACH Customer
WHERE Customer.Cust-num = 1 NO-LOCK,
EACH Order OF Customer NO-LOCK.