Posted by bbla32 on 02/19/07 21:40

On Feb 19, 10:31 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> You are missing naming the derived table. Note the AS tbl at the end of the inner query:
>
> SELECT ...
> FROM
> (
> SELECT ... FROM...
> ) AS tbl
> WHERE ...
> GROUP BY...


Thanks!

Can I write a faster query?

• Next in forum: Re: Replace Multiple Spaces with One Space?
• Prev in forum: Re: a substitute for UNION?
• Thread view: Re: a substitute for UNION?

[Reply to this message]