20091028_SQL_union all; left join ;right join's learning

It's really hard to learn if you read the exists code, the real problem is the best teacher. ^_^

 

for union all

SELECT * FROM table_1
union all
SELECT * FROM table_2

 

 

the returen result is : table_1's column name, table_1 's data and table_2's data.

 

untill now, I haven't konw what's the function.

 

but if table_1 and table_2 have different column count. the result will be :

使用 UNION、INTERSECT 或 EXCEPT 运算符合并的所有查询必须在其目标列表中有相同数目的表达式。

====================================================================