内连接有两种方法,示例如下,供您参考:
1.select a.column1,a.column2,b.column1,b.column2 from table_first a, table_second b
where a.column1=b.column1 and b.column3>5 and a.column2=b.column3;
2.select a.column1,a.column2,b.column1,b.column2 from table_first a inner join table_second b on a.column1=b.column1 and b.column3>5 and a.column2=b.column3;
具体点 把题目说出来!