Open MBulli opened 12 years ago
Thank you for reporting. I will take a look this weekend. If you have a chance could you submit a failing test? Would make it easier for me to track down.
[Test]
public void JoinOnSuppliersProducts()
{
var db = Database.OpenFile(DatabasePath);
var data = db["Suppliers"].Find(db["Suppliers"]["Products"]["SupplierID"] == db["Supplieres"]["SupplierID"]).ToList();
var item = data.First();
Assert.Pass();
}
This test is design for the northwind.db and should generate a query like that:
SELECT *
FROM Suppliers JOIN Products
ON (Suppliers.SupplierID = Products.SupplierID)
There is also another syntax for joins but I can't figure out how it works ...
Hi,
given the following Tables:
This line fails:
The generated SQL statement:
As far as I can tell the tables in the ON part are inverted. I tested it with: Simple.Data.Core/Ado v0.12.2.2 and Simple.Data.Sqlite v0.12.2.4.
I also checked the behavior of the sqlserver which is doing it right.