Natural Join syntax error
Mark Schonewille
m.schonewille at economy-x-talk.com
Fri Jul 31 03:35:18 CDT 2015
Thanks for the reply, Ivan. Which syntax do you recommend, for joining two tables? In MySQL I'd simply use
SELECT * from table1,table2 WHERE table1.a=table2.a
but this doesn't work either in Valentina. Sometimes I get empty results, while I know that table1.a and table2.a have records in common, and sometimes I get an error saying that the tables are not linked.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553
Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour spaces. http://www.color-converter.com
We have time for new software development projects. Contact me for a quote.
On 30 jul 2015, at 14:19, Ivan Smahin wrote:
> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
More information about the Valentina
mailing list