How to define DAL query to retrieve items and theirs tags? I have following tables:
'message' <--> 'tagging'(maty-to-many between message and tag tables) <---> 'tag' How to retrieve list of all mesages and their assotiated tags so I can list messages in a view like this: 1. message text 01 (tags: tag01, tag03) 2. message text 02 (tags: tag03, tag05, tag06) etc. I looked to web2py book to 'One to Many Relation' examples but they returns items in a way that gives me result like this: 1. message text 01 (tags: tag01) 2. message text 01 (tags: tag03) 3. message text 02 (tags: tag03) 4. message text 02 (tags: tag05) 5. message text 02 (tags: tag06) There must be something I missed. David