Natural Join syntax error

[Ruslan Zasukhin]

On 7/31/15, 11:35 AM, "Mark Schonewille" <m.schonewille at economy-x-talk.com>
wrote:

Hi Mark,

> 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.

This syntax of course works in Valentina DB, although this is deprecated
syntax.

Provide please any example DB and query where this not works for you.

Best of all via Mantis
 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]