selece *from table1,table2与select*from table1 union select*from table2的区别
selece*fromtable1,table2与select*fromtable1unionselect*fromtable2的区别用select*fromtable1unionselect*fromtable2能过实现两个表的查询但是用selece*fromtable1,table2时就出现... selece *from table1,table2与select*from table1 union select*from table2的区别用select*from table1 union select*from table2能过实现两个表的查询但是用selece *from table1,table2时就出现Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)ODBC 驱动程序不支持所需的属性。/haiger/serch.asp, 第 98 行请各位大侠指点 展开
最佳答案
回答者：网友
联合怎么会是一样呢？？？
table1中有 field1 field2 field3 (others)
table2中有 field1 field2 field3 (others)
select field1,field2,field3 from table1 union select field1,field2,field3
得到的表结构为：field1 field2 field3
select table1.*,talbe2.* from table1,talbe2
得到的表结构是 (field1,field2,field3,(others))table1,(field1,field2,field3,(others))talbe2
实在是懒得写全，如果懂的人应该知道，俺这里的*是他要的字段名，类型一样的字段名，不是sql是的*,嘎嘎！
