oracle中语句可以这样写: SELECT * from
script a,
cust_info b
where a.cust_id=b.cust_id(+)但是mysql中这样写就报错,是不是能这样用(+)?
那么用什么来代替呢?
附错误信息:---------------------------
错误
---------------------------
SQL 执行错误 # 1064. 从数据库的响应:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
---------------------------
确定
---------------------------
script a,
cust_info b
where a.cust_id=b.cust_id(+)但是mysql中这样写就报错,是不是能这样用(+)?
那么用什么来代替呢?
附错误信息:---------------------------
错误
---------------------------
SQL 执行错误 # 1064. 从数据库的响应:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
---------------------------
确定
---------------------------
select *
from shan_1130 a left join shan_1131 b on a.cust_id=b.cust_id;
script a right join
cust_info b on a.cust_id=b.cust_id