假如列名为sno 有S表 和C 表 则 select s.sno from s 或者 select c.sno from c
select a.colname as colname1,b.colname as colname2 from table1 a,table2 b where .......
