Natural Join syntax error

[Ivan Smahin]

Hi Mark,

> On Jul 31, 2015, at 11:35 AM, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
> 
> 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.
> 

No, it works perfectly in Valentina. If you have some difficulties - please send me particular db and particular query, so I would be more specific answering your questions.


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