[摘要]+-------------+----------------+-----------------+-----------------+3 rows in set (0.00 sec)mysql&g...
+-------------+----------------+-----------------+-----------------+
3 rows in set (0.00 sec)
mysql>
接下来我们就使用MySQL的JOIN来连接以上两张表来读取runoob_tbl表中所有runoob_author字段在tcount_tbl表对应的runoob_count字段值：
mysql> SELECT a.runoob_id, a.runoob_author, b.runoob_count
-> FROM runoob_tbl a, tcount_tbl b
-> WHERE a.runoob_author = b.runoob_author;
+-------------+-----------------+----------------+
关键词：案例详细说明Mysql中Join的应用