X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/626e02403cbcee241b2be41f3c2d827663864523..a5f30bf0b12c7e02f545f06215b4b10f01fa12d0:/SL/Form.pm diff --git a/SL/Form.pm b/SL/Form.pm index 5fb58aff2..a0fa96a2c 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -1765,10 +1765,9 @@ sub lastname_used { $where = "quotation = '1'"; } - my $query = qq|SELECT id FROM $arap - WHERE id IN (SELECT MAX(id) FROM $arap + my $query = qq|SELECT MAX(id) FROM $arap WHERE $where - AND ${table}_id > 0)|; + AND ${table}_id > 0|; my $sth = $dbh->prepare($query); $sth->execute || $self->dberror($query);