JavaSql相关

别名 v.name e    e代表别名
--------多表查询----sql----

sql = "select p.poId,p.createTime,v.name,p.tipFee,p.productTotal,p.poTotal,p.payType,p.prePayFee,p.status from pomain p,vender v where p.venderCode=v.venderCode";
}else{ 
 sql = "select p.poId,p.createTime,v.name,p.tipFee,p.productTotal,p.poTotal,p.payType,p.prePayFee,p.status from pomain p,vender v where p.venderCode=v.venderCode and p.payType="+status;
}

---------------
select p.poid ,p.VenderCode,v.name from pomain p, vender v
       where p.VenderCode=v.VenderCode

select p.poid,p.VenderCode,p.createtime,p.Account c.name from pomain p,customer c where p.VenderCode=c.CustomerCode