📄 slide036.html

📁 《Big C++ 》Third Edition电子书和代码全集-Part1

💻 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 + -