Question

java数据库操作如何进行多表查询

如何进行多表的查询操作?
sql="select * from scoretable where scoretable.num=table1.num and table1.A>11";
不能运行,不知道是怎么回事.
单独查询scoretable和table1都可以.

Answer 1

select scoretable.*,table1.* from scoretable,table1 where scoretable.num=table1.num and table1.A>11

Answer 2

select * from scoretable,table1 where scoretable.num=table1.num and table1.A>11
from 后面少了 table1

Answer 3

select * from scoretable join table1 on (scoretable.num=table1.num) where table1.A > 11

Answer 4

select * from scoretable,table1 where scoretable.num=table1.num and table1.A>11

Answer 5

select * from scoretable,table1 where scoretable.num=table1.num and table1.A>11