12.18 高级SQL学习
作者:jvfans 日期:2007-12-18
继续前面的，我们有三个表sales,sales_rep,customer，下面我们使用查询语句：
====
mysql> select first_name,surname,value from customer,sales where id=customer;
+------------+-------------+-------+
| first_name | surname | value |
+------------+-------------+-------+
| Yvonne | Clegg | 2000 |
| Winston ...
====
mysql> select first_name,surname,value from customer,sales where id=customer;
+------------+-------------+-------+
| first_name | surname | value |
+------------+-------------+-------+
| Yvonne | Clegg | 2000 |
| Winston ...
