Help with creating a Select within the Web2Py DAL for a SQL query that uses an 'exists' clause

[George D Elig]

I have a simple SQL query that pulls a column value from a secondary table, based on a ID being equal in both tables. The query uses an exists clause on a subquery.

select sites.domain_name, batch.batch_name from sites, batch

where exists (select batch.id from batch

              where sites.batchid = batch.id) limit 1