Natural Join syntax error

[Mark Schonewille]

Hi Ivan and Ruslan,

Indeed, I made a very simple test database and it works. Apparently, 
there is something peculiar about the production database. We will 
investigate the issue and if we can't find the cause, I'll ask the owner 
of the database if we can send it to you.

--
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/31/2015 14:04, Ivan Smahin wrote:
> 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.
>
>