Re: What's wrong with this query ?

You dont need the '(' around the Where clause. "Drazen" <drazen_candy__at_gmx.net> wrote in message news:a6glc2$102$1_at_sunce.iskon.hr...
> I am trying to find duplicate values in table "tab" in column "att", the
> query written in Microsoft Access works just fine and in Oracle it does
 not,
> what should it look like? The query is:
>
> SELECT * FROM tab WHERE (tab.att IN (SELECT att FROM TAB AS TMP GROUP BY
 att
> HAVING COUNT (*)>1));
>
> Regards,
>
> Drazen,
>
> ===================================
> Eat the candy to see my address better !
>
> Candy spam protection :)
> ===================================
>
>
Received on Sun Mar 10 2002 - 22:29:04 CET