Naz Gassiep wrote:
Hi,
If I have a table with users and a table with messages, is it
possible to have a query that returns user.* as well as one extra column
with the number of messages they have posted and the data and time of
the last message? At the moment I am using a subquery to do this,
however it seems suboptimal. Is there a better way?
Not really. You have three separate queries really:
1. User details
2. Total number of messages posted
3. Details on last message posted
Unless you have a messaging-summary table that you keep up-to-date with
triggers you're looking at a three-part query.
--
Richard Huxton
Archonet Ltd
