On Sat, 21 Jul 2007 16:20:01 +0200, P.A. <anschouwe@yahoo.com> wrote:
> mysql> SELECT IFNULL(min(a.lowestnum) AS num_new FROM (SELECT id_staff+1
> AS lowestnum FROM staff_data) a WHERE a.lowestnum NOT IN (SELECT
> id_staff FROM staff_data), '1');
> ...which does not work :-(


SELECT IFNULL(min(a.lowestnum),1) AS num_new FROM (SELECT id_staff+1
AS lowestnum FROM staff_data) a WHERE a.lowestnum NOT IN (SELECT id_staff
FROM staff_data);
--
Rik Wasmus

Am 21.07.2007, 16:47 Uhr, schrieb Rik <luiheidsgoeroe@hotmail.com>:

> SELECT IFNULL(min(a.lowestnum),1) AS num_new FROM (SELECT id_staff+1
> AS lowestnum FROM staff_data) a WHERE a.lowestnum NOT IN (SELECT
> id_staff FROM staff_data);

Yep, that works! Thought I tried that before but probably missed something.

Thanks!

Pascal.


--