I'm trying to take the following MySQL query
SELECT recipient.emailAddress
FROM recipient
LEFT JOIN mr_link ON recipient.id = mr_link.recipID
and turn it into a DAL query, but I keep running into 'keyword' issues
My code is as such:
rows = db().select(db.recipient.emailAddress, db.mr_link.ALL, left=db.
mr_link.on(db.mr_link.recipID=db.recipient.id))
but I keep receiving
<type 'exceptions.SyntaxError'> keyword can't be an expression (default.py,
line 25)
Assistance in solving this would be very helpful
Thanks
--