Hi all,
I'm writing several queries with multiple tables, and left joins, and
the generated SQL is not working with postgres:
ProgrammingError: invalid reference to FROM-clause entry for table
"concert"
LINE 1: ..., artist LEFT JOIN audiofile ON
audiofile.concert=concert.id...
^
HINT: There is an entry for table "concert", but it cannot be
referenced from this part of the query.
my query is:
query = db((db.concert_purchases.auth_user == auth.user.id) &
(db.concert.id == db.concert_purchases.concert) &
(db.concert_purchases.expires > now) &
(db.artist.id == db.concert.artist) &
(db.venue.id == db.concert.venue))
rows = query.select(db.concert.name, db.concert.id,
db.concert_purchases.date,
db.artist.name,
db.venue.name,
db.concert.date,
db.audiofile.file,
left=db.audiofile.on(db.audiofile.concert ==
db.concert.id),
orderby=~db.concert_purchases.date)
I have web2py Version 1.63.5 (2009-06-03 23:35:00)
so, is there a way i can write the query to make the left join work,
or should i just do multiple queries?
thanks for the help,
christian
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
