I wrote:
A question on the empty section 'Custom Join Condition' in the Advanced Data Mapping - if I have two tables, say Company and DailyStockPrice (which has volume, open, close columns), it is easy to define a relation to get *all* the daily prices for a particular company, but what if I want to retrieve only the prices at the end of a week or a month. The sql is fairly straightforward (involving subqueries), but how can I setup a mapping to include this (likely) textual sql as the join condition?
On reflection this particular example should probably be a custom query, but I'm interested in the capabilities of custom join conditions and would still appreciate any insight/comments.
Robert ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
