How do you reference fields from different tables using a where clause? and the data you extract it from QVD's file.

[Anonymous]

How do you reference fields from different tables using a where clause? and the data you extract it from QVD's file.

Example:

Customer:

LOAD Customer_ID

Customer_Name

Address

FROM

(qvd);

Order:

LOAD ORDER_ID

Description

Amount

Order_Date

FROM

(qvd);

Question is how do you select only the orders pertaining certain customer_ID's

Order:

LOAD ORDER_ID

Customer_ID

Description

Amount

Order_Date

FROM

(qvd); Where (Order.Customer_ID = Customer.Customer_ID)

I get an error if i try to do it this way. Can anyone help

[neelamsaroha157]

One way is to use Exist function.

Check this out -

Where Exists() and resident load

[Anonymous]

Thank you. The Where Exist works perfectly