SELECT users.username FROM users, drivers WHERE users.userid=drivers.userid AND drivers.name="John"

##</code><code>##

my $sql = SQL::Abstract->new;
my($stmt2, @bind2) = $sql->select("users, drivers", ["users.username"], {"drivers.name" => "John"});

##</code><code>##

$stmt2 = "SELECT users.username FROM users, drivers WHERE ( drivers.name = ? )"
@bind2 = ("John")

##</code><code>##

my($stmt2, @bind2) = $sql->select("users, drivers", ["users.username"], {"drivers.name" => "John","users.userid" => "drivers.userid"});

##</code><code>##

$dbh->select({
    fields=>'*',
    table=>'foo,bar',
    join=>'foo.id=bar.foo_id',  ## <--- HERE
    where=>{'foo.dollars',['>',30]}
    });