title: Oracle to mysql conversion
body: <p>how do i convert from oracle to sql?</p>
  <p>any difference putting (+) on the left or (+) right side?</p>
  <p>can assist convert it for me, trying online tools doesnt work for me.</p>
  <pre><code>SELECT sc.serial_no, sc.status, ca2.cust_ref_no, ca2.name, ca2.msis, ca2.state_name, to_char(ca2.term_datetime,'DD/MM/YYYY HH:MI AM') te_datetime, ca2.serial_no term_ssno 
  from so sc,  
  ( select ca.so_id, c.cust_ref_no, c.name, ca.msis, s.state_name, ca.te_datetime, t.serial_no 
  from customer c, customer_account ca, state s, terminal t 
  where c.install_state_id= s.state_id and c.cust_id = ca.cust_id and ca.term_id = t.term_id(+)) ca2 
  where sc.so_id=ca2.so_id (+)and sc.status='Term' 
  </code></pre>