Hi,

I am doing a search across two tables for matching records, and I'm  
not quite sure how to work with the results of the query. For example:

matches = session.query(TableA).from_statement("SELECT tableA.id,  
tableB.id FROM tableA, tableB WHERE <etc>")

To me this doesn't really fit the model. The "query(TableA)" part  
isn't right since I'm not returning rows of TableA. Is there a way I  
can create arbitrary queries like this?

Cheers,
Demitri

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to