散分了！关于mysql

Question

现在有三张表如下
第一张表 user
user_num     user_id
1            10000000001
2            10000000002
3            10000000003
4            10000000004
5            10000000005
...          ...第二张表 bookbook_num     book_id
1            21000000001
2            21000000002
3            21000000003
4            21000000004
5            21000000006第三张表 pvuser_id      book_id           pv
10000000002  21000000002       2
10000000004  21000000001       223
10000000001  21000000004       23
10000000003  21000000005       1
10000000005  21000000003       1
...          ...               ..第四张表 pv_resultuser_num    book_num     pv
2           2            2
4           1            223
1           4            23
3           5            1
5           3            1
...         ...          ...由于book, user 和pv 都比较大，数据多，现在请教一种比较高效的方法，把前三张表转换成第四张表。

Answer 1

select user.user_num,book.book_num,pv.pv
from pv,user,book
where pv.user_id=user.user_id
and pv.book_id=book.book_id创建user(user_id)
book(book_id) 的索引。

Answer 2

没啥简单方法
select *
from tb1 A,tb2 B,tb3 C
where A.user.user_id=C.user_id and B.bookid=c.bookid