Closed deawx closed 3 years ago
Medoo Version 1.7.10 This my code $r = $db->select("item(a)", [ "[>]customer(b)" => ["customer_id" => "id"] ], [ "a.id", "b.company_name" ], [ "a.id" => 437565 ]); i debug is show SELECTa.id,b.company_nameFROMitemASaLEFT JOINcustomerASbONitem.customer_id=b.idWHEREa.id= 437565
$r = $db->select("item(a)", [ "[>]customer(b)" => ["customer_id" => "id"] ], [ "a.id", "b.company_name" ], [ "a.id" => 437565 ]);
SELECT
.
,
FROM
AS
LEFT JOIN
ON
=
WHERE
= 437565
i think Should be is ONa.customer_id=b.id``
Thank you catfan
This has been fixed on cac5738.
catfan
commented
3 years ago catfan
commented
3 years ago
Medoo Version 1.7.10 This my code
$r = $db->select("item(a)", [ "[>]customer(b)" => ["customer_id" => "id"] ], [ "a.id", "b.company_name" ], [ "a.id" => 437565 ]);i debug is showSELECTa.id,b.company_nameFROMitemASaLEFT JOINcustomerASbONitem.customer_id=b.idWHEREa.id= 437565i think Should be is
ONa.customer_id=b.id``Thank you catfan