sqljoin的用法.docVIP

关于sql语句中的连接（join）关键字，是较为常用而又不太容易理解的关键字，下面这个例子给出了一个简单的解释 --建表table1,table2：create table table1(id int,name varchar(10))create table table2(id int,score int)insert into table1 select 1,leeinsert into table1 select 2,zhanginsert into table1 select 4,wanginsert into table2 select 1,90insert into table2 select 2,100insert into table2 select 3,70如表-------------------------------------------------?table1? | table2? |-------------------------------------------------id? name |id? score |1? lee |1? 90 |2? zhang |2? 100 |4? wang |3? 70 |-------------------------------------------------