Hi peterlu
I think you're going to need separate calls. One to get the messages, such as:
SELECT messages FROM users WHERE roles.name IN ('Administrator', 'BlogAuthor')
And then using the returned query from there to get the message data... something like:
SELECT * FROM messages WHERE author.id IN ('3','17','43')
@SusanH, thanks for the info. The only problem of this solution is that it is not scalable. When there are a lot of authors of certain roles, the performance is not great. So we probably have to add in a date range into WHERE to limit the query.
