[Zope-DB] Selection Statement in ZSQL method with Conditional matching

Tue May 11 22:59:31 EDT 2004

I need to select fields by joining two tables. 

There is conflict between two fields to be matched. The field "orderline" need to be divided by 1000 or 100 depending on order type and then can be matched with the field from the other table.

I am wondering which conditional statement is usable. I am thinking to put conditional statement in OUTER JOIN 'on' statement. 

Please mail me any possible syntax.

---------------------------------
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2' 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20040511/212c5da4/attachment.html