我用sql数据库中的示例数据库中的pubs数据库。
select * from titles ,titleauthor, titleview
join on titles.title_id=titleauthor.title_id
join on titleview.price=titles.price请指正,不胜感激
select * from titles ,titleauthor, titleview
join on titles.title_id=titleauthor.title_id
join on titleview.price=titles.price请指正,不胜感激
join titleauthor
on titles.title_id=titleauthor.title_id
join titleview
on titleview.price=titles.price
on c.price=a.price
on c.price=a.price
or
select * from titles a ,titleauthor b,titleview c
where a.title_id=b.title_id and c.price=a.price