FROM branchtransfers

        FROM branchtransfers

        WHERE itemnumber = ?

        WHERE itemnumber = ?

          AND datearrived IS NULL

          AND datearrived IS NULL

        ';

        ';

    my $sth = $dbh->prepare($query);

    my $sth = $dbh->prepare($query);

    $sth->execute($itemnumber);

    $sth->execute($itemnumber);