Figure 17: Another simple query

SELECT	C.CUSTOMER,

	S.ORDERDATE

FROM	SALES S,

	CUSTOMERS C

WHERE	S.CUSTKEY = C.CUSTKEY          <=join predicate

AND	S.ORDERDATE = '2005/06/30';    <=local selection predicate