tags:

views:

12

answers:

0
Q: 

How to represent SQL statement in SQLObject.

How do I represent the following SQL statement in SQLObject? The document is not very clear for me.

SELECT report_params.*
FROM report_params
JOIN report_freq_map ON report_id = report_params.id
JOIN report_frequency ON freq_id = report_frequency.id
WHERE frequency = 'daily'

Thanks, -peter

related questions

Django: Store Hierarchical Data
Python: get escaped SQL string
create temporary table from cursor
SQL get data out of BEGIN; ...; END; block in python
sql select from a large number of IDs
sqlobject: No connection has been defined for this thread or process
SQL Server: Can INFORMATION_SCHEMA Tell Me When a SQL Object Was Created?
SQLObject: How do I prevent a specific class from being cached?
Using illegal names in MySQL through SQLObject
Sorting by a field of another table referenced by a foreign key in SQLObject
Is this a good approach to avoid using SQLAlchemy/SQLObject?
How to do create_or_update in sqlobject?
Error while importing SQLObject on Windows
Executing SQL LIKE in SQLObject
Any reasons not to use SQLObject over SQLAlchemy?
IronPython db-api 2.0
Database change underneath SQLObject