有两张表,table1,table2,里面字段相似,或者说一样;
当两张表链接起来后,发现有重名的列,该如何处理,绑定gridview的时候,怎样识别?
比如,链接起来后的表为:
id name department id name department;
第一为tabel1中的,第二个为table2中的。
当两张表链接起来后,发现有重名的列,该如何处理,绑定gridview的时候,怎样识别?
比如,链接起来后的表为:
id name department id name department;
第一为tabel1中的,第二个为table2中的。
table2.id,table2.name.table2.department from table1,table2或用表别名select t1.id,t1.name,t1.department,
t2.id,t2.name.t2.department from table1 t1,table2 t2
select t1.id as id1,t1.name as name1,t1.department as department1,
t2.id as id2,t2.name as name2,t2.department as department2 from table1 t1,table2 t2
select table1.id,table1.name,table1.department,
table2.id,table2.name.table2.department from table1,table2
或用表别名
SQL code
select t1.id,t1.name,t1.department,
t2.id,t……