Natural Join syntax error

[Beatrix Willius from Moth Software]

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