Natural Join syntax error

Ivan Smahin ivan_smahin at paradigmasoft.com
Thu Jul 30 07:19:33 CDT 2015


Hi Mark,

> On Jul 29, 2015, at 10:10 PM, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
> 
> What is wrong with this syntax?
> 
> SELECT * FROM table1 NATURAL JOIN table2
> 
> I get error 0x55000 which is a SQL syntax error. According to the documentation at
> 
> http://www.valentina-db.com/docs/dokuwiki/v6/doku.php?id=valentina:vcomponents:vsql:reference:select:join
> 
> the syntax should be correct (scroll down do Natural Join).
> 

Actually, the WIKI page must be fixed.
Currently we don't support "NATURAL" join as it is commonly considered as deprecated feature.


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



More information about the Valentina mailing list