sqlite - Unsupported Sql

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 28,34 ****
        FROM table1 t1, table2 t2
        WHERE t1.t2_ref_id *= t2.id
  
!       This is Sybase ASE syntax. Related to "Oracle's join syntax" mentioned below. Use LEFT JOIN or RIGHT JOIN instead.
  
  *: 2005.12.27 : Oracle's Named Parameter output syntax.  In Oracle, one can declare parameters and select into them as such
  
--- 28,35 ----
        FROM table1 t1, table2 t2
        WHERE t1.t2_ref_id *= t2.id
  
!       This is Sybase ASE syntax. Use LEFT JOIN or RIGHT JOIN instead.
!       (This is related to "Oracle's join syntax" mentioned below.)
  
  *: 2005.12.27 : Oracle's Named Parameter output syntax.  In Oracle, one can declare parameters and select into them as such