有关JOIN的更多信息：

http://msdn.microsoft.com/en-us/library/ms173815.aspx [ ^ ]

http://www.sqlteam.com/article/writing-outer-joins -in-t-sql [ ^ ]

http://www.w3schools.com/sql/ sql_join.asp [ ^ ]

在 SQL联接 [ ^ ]

 选择 * 来自 table1 e  join  table2 e1  on  e.id = e1.id 

两个表中都应该有一个公共字段。

How to use join in sql
How to use join in sql

More about JOIN:
http://msdn.microsoft.com/en-us/library/ms173815.aspx[^]
http://www.sqlteam.com/article/writing-outer-joins-in-t-sql[^]
http://www.w3schools.com/sql/sql_join.asp[^]

One quite good tutorial is found at SQL Joins[^]

select * from table1 e join table2 e1 on e.id=e1.id

There should be a common field in both tables.