It's pretty easy in SQL::Abstract to force an AND situation when you have two (or more) conditions on the same column, just use an arrayref where the first element is '-and'. E.g.:

  {
    create_date => [-and => {'>=' => $start_date},
                            {'<=' => $end_date}]
  }
[download]

which produces:

  WHERE ( ( ( create_date >= ? ) AND ( create_date <= ? ) ) )
[download]

For your case you would use:

  {
    'users.userid' => [-and => {'=' => 1000},
                               \'= drivers.userid']
  }
[download]

which produces:

  WHERE ( ( ( users.userid = ? ) AND ( users.userid = drivers.userid )
+ ) )
[download]

HTH, Larry