And I've got it...
(well, it'd be close to say you've got it, but you know ;-p )
I've learnt another little string to the sql bow, cheers again Rudy..
Now if I can just remember it!!! ;-p
On 04/12/06, r937 <[EMAIL PROTECTED]> wrote:
> Ok, So when I put my WHERE clause, just before GROUP BY, it gets an
> error...
unfortunately, my crystal ball is down at the moment
(it does this often, because it runs on windows)
therefore you will have to show me the query
oh, and please don't forget to mention what the error was
> What was SELECT 1 all about, I've never seen that before...
it's an EXISTS subquery -- it can select anything
the important part of an EXISTS subquery is that it will evaluate TRUE if
the subquery returns at least one row -- but it doesn't matter what that row
contains
i will routinely write it like this --
... where exists ( select 937 from ... )
but i refrained from doing so this time because i figured it would confuse
you unduly
;o)
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
