Файл: work/sql_teach/e.php
Строк: 46
<?
require '../../config.php';
$title = 'Основы SQL';
include '../../style/head.php';
aut();
who_add(0, 'servise');
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head>
<link rel="stylesheet" href="css.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="ru">
<title>Приложение E.</title></head>
<body>
<h1>Приложение E</h1><hr width="50%">
<h1>ТАБЛИЦЫ SQL, ИСПОЛЬЗУЕМЫЕ В ЭТОЙ КНИГЕ</h1>
<p><br>
</p>
<pre>==================== ТАБЛИЦА 1: ПРОДАВЦЫ ================
----------------------------------------------
snum | sname | city | comm
--------|-----------|--------------|----------
1001 | Peel | London | .12
1002 | Serres | San Jose | .13
1004 | Motika | London | .11
1007 | Rifkin | Barcelona | .15
1003 | Axelrod | New York | .10
---------------------------------------------
================== ТАБЛИЦА 2: ЗАКАЗЧИКИ ===============
----------------------------------------------
cnum | cname | city | rating | snum
-------|------------|---------|--------|------
2001 | Hoffman | London | 100 | 1001
2002 | Giovanni | Rome | 200 | 1003
2003 | Liu | SanJose | 200 | 1002
2004 | Grass | Berlin | 300 | 1002
2006 | Clemens | London | 100 | 1001
2008 | Cisneros | SanJose | 300 | 1007
2007 | Pereira | Rome | 100 | 1004
----------------------------------------------
================== ТАБЛИЦА 3: ЗАКАЗЫ ==================
-----------------------------------------------
onum | amt | odate | cnum | snum
-------|-----------|-------------|------|------
3001 | 18.69 | 10/03/1990 | 2008 | 1007
3003 | 767.19 | 10/03/1990 | 2001 | 1001
3002 | 1900.10 | 10/03/1990 | 2007 | 1004
3005 | 5160.45 | 10/03/1990 | 2003 | 1002
3006 | 1098.16 | 10/03/1990 | 2008 | 1007
3009 | 1713.23 | 10/04/1990 | 2002 | 1003
3007 | 75.75 | 10/04/1990 | 2004 | 1002
3008 | 4723.00 | 10/05/1990 | 2006 | 1001
3010 | 1309.95 | 10/06/1990 | 2004 | 1002
3011 | 9891.88 | 10/06/1990 | 2006 | 1001
-----------------------------------------------</pre>
</body></html>
<?php
echo '« <a href="/work/?">В Раздел</a>';
include '../../style/foot.php';
?>