i need to do a join on 3 tables to retreive 1 or 0 items
table account
account_id is_verified
table email
id email_address account_id (references account.id)
table verification_string
id verification_string email_id (references email.id )
each table has its own rose class with the approriate references
in plain sql it would be:
SELECT *
FROM account , email , verification_string
WHERE
account.id = email. account_id AND
email.id = verification_string.id AND
email.email_address= %s AND
verification_string.verification_string= %s
can this be done trivially in rosedb using the table/class objects?
or should i just stick to raw sql -- which i'm fine with
| - - - - - - - - - - - - - - - - - - - -
| RoadSound.com / Indie-Rock.net
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - -
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
