Natural Join syntax error

[Mark Schonewille]

I have decided to use the following syntax:

SELECT *
     FROM table1 LEFT OUTER JOIN table2
     ON table1.x=table2.x

I'm still interested in knowing why natural join doesn't work.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Installer Maker for LiveCode:
http://qery.us/468

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

LiveCode on Facebook:
https://www.facebook.com/groups/runrev/


On 7/29/2015 21:10, Mark Schonewille 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).
>
> --
> Best regards,
>
> Mark Schonewille
>