Hello, Im not sure that im sending this mail to the correct people, but Im really desperate right now.
I have a problem with a SELECT JOIN query. I have two tables, one which contains Articles, and one which contains ArticleUpdates. What I would like to do, is to have a report of Articles, which has some special values set in both ArticleUpdates and Articles. BUT in ArticleUpdates we have a column named EditedDate. We are ONLY interested in the last update of each Article. ArticleUpdates is linked to Articles by a column named ArticleID. So, an example query could be: We want to know about all articles that have been changed by user 1 (column: ArticleUpdates.EditedUser) and at the same time it has to be a member of department 20 (Articles.Department) If you could make a such query for me, I would very much appriciate it. A final note is, that it has to support Access databases aswell, so it should follow the SQL standard. Please get back to me as soon as possible, as I needed this done a week ago. Please write to this email address, as im not subscribed to the mailling list. Sincerely, Christian Rytter --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
