Question

学生表a有id,name,addressid字段，表b有addid,addres字段。addressid通过addid来对应addres，

如何用Oracle语句查询 address='XX'的学生信息！没分了郁闷。有没有大虾帮个忙看看

Answer 1

select a.*,b.addres from a join b on a.addressid=b.addid and b.address='XX';

Answer 2

select id,name,address from a,b where a.addressid=b.addid and b.address='XX';

追问

select a.id,a.name,b.address from a,b where a.addressid=b.addid and b.address='XX';
这样吧。。谢谢了。。