Problem with query builder
I am evaluating fr 3.15 and I just cannot believe this is happening with the query builder :
I am trying to build a simple query from the DBDEMOS alias
1 - I link "Orders.db" and "Items.db" using OrderNo as the linking field,
the query builder produces the following sql statement which is correct
SELECT o.OrderNo, i.PartNo
FROM
orders.db o
INNER JOIN items.DB i ON (o.OrderNo=i.OrderNo)
2 - But when I link "Items.db" and "Parts.db" using PartNo as the linking field,
the query builder produces the following sql statement which is not correct
(Note: I have 3 tables now)
SELECT o.OrderNo, i.PartNo, p.Description
FROM
orders.db o
INNER JOIN items.DB i ON (o.OrderNo=i.OrderNo) AND (o.PartNo=i.PartNo) ,
parts.db p
I am trying to build a simple query from the DBDEMOS alias
1 - I link "Orders.db" and "Items.db" using OrderNo as the linking field,
the query builder produces the following sql statement which is correct
SELECT o.OrderNo, i.PartNo
FROM
orders.db o
INNER JOIN items.DB i ON (o.OrderNo=i.OrderNo)
2 - But when I link "Items.db" and "Parts.db" using PartNo as the linking field,
the query builder produces the following sql statement which is not correct
(Note: I have 3 tables now)
SELECT o.OrderNo, i.PartNo, p.Description
FROM
orders.db o
INNER JOIN items.DB i ON (o.OrderNo=i.OrderNo) AND (o.PartNo=i.PartNo) ,
parts.db p