X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/3bc869ddc37202dfb0f810178ebea7cd5668303d..b90f03e45d33ac76d0d5ec34132831bfbf55e15d:/SL/DO.pm diff --git a/SL/DO.pm b/SL/DO.pm index 620f1e06a..ef6a10b69 100644 --- a/SL/DO.pm +++ b/SL/DO.pm @@ -393,7 +393,7 @@ sub mark_orders_if_delivered { my $all_units = AM->retrieve_all_units(); - $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit + my $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit FROM orderitems oi LEFT JOIN parts p ON (oi.parts_id = p.id) WHERE (oi.trans_id = ?)|;