DataMapper ORM v1.8.0

[eluser]jez123[/eluser]
Thanks for your help. That query is completely different from having an AND because not only of efficiency

http://greensweater.wordpress.com/2008/0...onditions/

But also if you have multiple joins then including the condition in the where part of the query will return a completely different result set

I'm surprised it can't be done actually, because the query restricts the result set to a specific criteria (e.g., 23 is the value of a logged in user in the session), so it should have nothing to do with foreign key constraints, and is quite commonly done in SQL. Guess I'll have to write my own function in the datamapper library or get rid of it for something less restrictive.