Data Virtualization for Business Intelligence Systems by Rick F. van der Lans

Author:Rick F. van der Lans
Language: eng
Format: epub
ISBN: 9780123978172
Publisher: Elsevier Inc.
Published: 2012-07-08T16:00:00+00:00

Let’s continue with the more complex example in Example 6.6.

Example 6.6

Imagine that three source tables are joined. The first two, CUSTOMER_ORDER_LINE and CUSTOMER_ORDER, are stored in one data store, and the third, CUSTOMER, is stored in another one.

SELECT COL.CUSTOMER_ORDER_LINE_ID, CO.CUSTOMER_ORDER_ID, C.REGION_ID

FROM CUSTOMER_ORDER_LINE AS COL, CUSTOMER_ORDER AS CO, CUSTOMER AS C

WHERE COL.CUSTOMER_ORDER_ID = CO.CUSTOMER_ORDER_ID

AND CO.CUSTOMER_ID = C.CUSTOMER_ID

AND CO.PROMOTION_ID > 10

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.