SQL JOIN query problem

2002-09-02 Thread Christian Rytter 

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

Problems with MySQL useing MyODBC and ASP on NT5

2001-03-09 Thread Christian Rytter 

Hello

I have installed the MySQL server on a Windows 2000 server, and set up passwords and 
usernames. And one database with 3 tables. Each tables uses auto increment fields. 
(these are marked as index fields as they should be).

And then i have inserted a few test records. When i do a standard query useing mysql 
promt, it looks fine.("SELECT * FROM tbl;") But when i do it in ASP useing a DSNless 
connection in ADODB it dosnt work. When i specify which fields it should return, it 
does the same. But when i remove the autoincrement id field, it works fine. ("SELECT 
name, desc FROM tbl;")

What could be wrong?

Venlig Hilsen / Best regards
Christian Rytter
AC Software
[EMAIL PROTECTED]
http://www.ac-ware.com