On 3 feb 2006, at 11.43, Nigel Bishop wrote:
The query will have the username and domain passed in as variables.
If the username and domain exist then return the sendto
The bit I’m struggling with is if the username doesn’t exist then
return the sendto where the domain exists
e.g. username=fred (this doesn’t exist) and domain=rusty.com then
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
I think this could do the trick for you:
SELECT sendto FROM users t1
WHERE domain='rusty.com' AND (username='fred') = EXISTS(SELECT 1 FROM
users t2 WHERE username='fred' and domain=t1.domain);
Sincerely,
Niklas Johansson
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
