请先看如下语句:
select a.bianhao,b.feiyong from table1 a,table b where a.bianhao=b.bianhao and a.yuefen=b.yuefen and a.bianhao>100现在我想使用左连接:于是写了下面的语句:
select a.bianhao,b.feiyong from table1 a left outer join table b on a.bianhao=b.bianhao and a.yuefen=b.yuefen and a.bianhao>100于是出现了错误提示:"不支持连接表达式???这是怎么回事呢???多条件之间不能用and吗?谢谢各位!!!
select a.bianhao,b.feiyong from table1 a,table b where a.bianhao=b.bianhao and a.yuefen=b.yuefen and a.bianhao>100现在我想使用左连接:于是写了下面的语句:
select a.bianhao,b.feiyong from table1 a left outer join table b on a.bianhao=b.bianhao and a.yuefen=b.yuefen and a.bianhao>100于是出现了错误提示:"不支持连接表达式???这是怎么回事呢???多条件之间不能用and吗?谢谢各位!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货