ID difference.......

[ethan]

Hi,

I am running a query off of one table of articles that simply returns articleID, title, article, and image

Code:

SELECT articleID, title, article, image
FROM Articles
The articleID is an auto-increment INT field and I just need to have the query also return one more field that will indicate the difference between that particular articleID and the max articleID. So, for example, if an article has articleID 100 but the most recent articleID is 120 I need a field to return the number 20.

I know how to do this with a subquery but I am using MySQL version 4.0.1 so can’t use subqueries.

Give your suggestions -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[winnie]

Use two queries

SELECT max(articleID) /* gives 120 */
FROM Articles

SELECT articleID, title, article, image, 120 - articleID
FROM Articles -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --