Michael DePhillips wrote:
Hi Dan,
Thanks for the prompt reply,
As I described it yes, you are correct, however, the id may not always
be one(1) value away. So the number one needs, somehow, to be replaced
with a way to get the "next largest value " and the "previous less
than" value.
Sorry for the lack of precision in my prior post.
What you want to do isn't possible in the form you want without
subqueries. Which would you prefer:
a) A single query returning one row of three columns containing nulls
b) A single query using sub queries (MySQL 4.1+ only) returning upto
three rows with one column
c) multiple queries
Nigel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]