Posted by Captain Paralytic on 06/19/07 08:41

On 19 Jun, 02:06, "cluthz" <WHATEEVVE...@by.co.uk> wrote:
> "Captain Paralytic" <paul_laut...@yahoo.com> wrote in message >
> > A basic example that should work can be found at the link I sent you
> > in my post!
>
> > What you are doing wrong is putting a comma where the working example
> > does not have one.
>
> OK great I'll try this out. any opinion on what those other links I sent say
> about it not being as efficient as running two sql queries in some cases?

As with pretty much everything, it is a case of "horses for courses".
You always need to look at what you need and decide on the best way of
accomplishing it in that particular case. Depending on various
criteria, I sometimes use this method in my apps and sometimes, where
there are different criteria, I use separate queries. There are always
many ways to "skin a cat", the programmer's challenge is to choose the
best one in the circumstances.

[Back to original message]