select * from(select * from a,b where a.schoolno = b.schoolno)as abc;
结果报错:Duplicate column name 'SchoolNO'请问这里是哪里出错了,如果把子查询里面的*号改成某些字段,这个查询就不会错,但我现在是想返回子查询里面的所有字段,请问该怎么写
结果报错:Duplicate column name 'SchoolNO'请问这里是哪里出错了,如果把子查询里面的*号改成某些字段,这个查询就不会错,但我现在是想返回子查询里面的所有字段,请问该怎么写
select * from (
select a.SchoolNO as a1,b.SchoolNO as b1,... from a,b where a.schoolno = b.schoolno) as abc;
orselect * from a,b where a.schoolno = b.schoolno
select * from (select * from a inner join b using(schoolno))as abc;
感谢各位的解答。结贴,给分