Natural Join syntax error

[Mark Schonewille]

Hi Beatrix,

I actually did a few SQL courses. The problem is that the simplest join that works with MySQL doesn't work with Valentina. Also see my answer to my own question, where I write which solution I decided to use.

--
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 31 jul 2015, at 11:18, Beatrix Willius from Moth Software wrote:

> Check out any SQL training website on how to use joins.
> 
> See for instance http://www.w3schools.com/sql/sql_join.asp
> 
> SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
> FROM Orders
> INNER JOIN Customers
> ON Orders.CustomerID=Customers.CustomerID;
> 
>> Am 31.07.2015 um 10:35 schrieb Mark Schonewille <m.schonewille at economy-x-talk.com>:
>> 
>> 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.
> 
> Mit freundlichen Grüßen/Regards
> 
> Trixi Willius
> 
> http://www.mothsoftware.com
> Mail Archiver X: The email archiving solution for professionals
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina