Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you. The Where Exist works perfectly