String sql="update 表1 set eMail='"+cus.geteMail()+"',registerTime='"+cus.getRegisterTime()+"',name='"+cus.getName()
+"',telephone='"+cus.getTelephone()+"',mobileTelephone='"+cus.getMobileTelephone()+"',address='"+cus.getAddress()
+"' from 表1 inner join 表2
on(表1.customerId=表2.Id) where Id='"+cus.getId()+"'";这样进行二表更新有没有错误啊?
为什么这样它说 eMail列名无效 eMail和registerTime是表2的列名
+"',telephone='"+cus.getTelephone()+"',mobileTelephone='"+cus.getMobileTelephone()+"',address='"+cus.getAddress()
+"' from 表1 inner join 表2
on(表1.customerId=表2.Id) where Id='"+cus.getId()+"'";这样进行二表更新有没有错误啊?
为什么这样它说 eMail列名无效 eMail和registerTime是表2的列名
+"',a.telephone='"+cus.getTelephone()+"',a.mobileTelephone='"+cus.getMobileTelephone()+"',a.address='"+cus.getAddress()
+"' from 表1 as a inner join 表2 as b
on(表1.customerId=表2.Id) where Id='"+cus.getId()+"'";
这样试试。。还有就是你看下传入的值符不符合