📄 slide036.html
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="blendTrans(Duration=2)" http-equiv="Page-Enter">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" src="./config.js"></script>
<script language="JavaScript" src="./pageFormat.js"></script>
<script><!-- // Set title on page
title()
//--></script>
</head>
<body>
<div onclick="document.location='slide037.html'">
<h2><font color="#009999">28.2.5 Joins (cont.)</font></h2>
<font size="+1">
<ul>
<li>E.g., find all cities that received a hair dryer:
<ul>
<li>Use Product table to match 'Hair Dryer' to items</li>
<li>Use Item table to find invoices</li>
<li>Use Invoice table to find customers</li>
<li>Pull info from Customer table</li>
</ul>
<blockquote>
<pre>SELECT Customer.City, Customer.State, Customer.Zip
FROM Product, Item, Invoice, Customer
WHERE Product.Description = 'Hair dryer'
AND Product.Product_Code = Item.Product_Code
AND Item.Invoice_Number = Invoice.Invoice_Number
AND Invoice.Customer_Number
= Customer.Customer_Number</pre>
</blockquote>
</li>
<table border='1' cellpadding='4'>
<tr><td align='center'>Anytown</td>
<td align='center'>CA</td>
</tr>
</table>
</ul>
</font>
<hr>
<center><small>
<a href='slide035.html'>prev</a>
|<a href='slide001.html'>top</a>
|<a href='slide037.html'>next</a>
</small></center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -