Update with join statement get error #204
Description
Hello, I'm try to update statement with join with another table but it got error.
$datas = array(
'tkt5d_win_level' => 0,
);
$db->join("5d_sale_ticket","tkt5d_tsn=tkt5d_tkt5d_tsn","INNER");
$db->where("tkt5d_d5d_draw_id", $draw_id);
$updated = $db->update("5d_sale_ticket_detail", $datas);
echo $db->getLastQuery();
UPDATE tbl_5d_sale_ticket_detail SET INNER JOIN tbl_5d_sale_ticket on tkt5d_tsn=tkt5d_tkt5d_tsntkt5d_win_level = ? WHERE rst5d_digit_1 = ? AND rst5d_digit_2 = ? AND rst5d_digit_3 = ? AND rst5d_digit_4 = ? AND rst5d_digit_5 = ? AND tkt5d_d5d_draw_id = ?
the correct statement should be:
UPDATE tbl_5d_sale_ticket_detail INNER JOIN tbl_5d_sale_ticket on tkt5d_tsn=tkt5d_tkt5d_tsn
SET tkt5d_win_level = ? WHERE rst5d_digit_1 = ? AND rst5d_digit_2 = ? AND rst5d_digit_3 = ? AND rst5d_digit_4 = ? AND rst5d_digit_5 = ? AND tkt5d_d5d_draw_id = ?