>hi
>so what am I doing wrong here
>
>
> SELECT pk FROM myTable where exists( SELECT * FROM myTable where id ="12345" )
>
>this returns every record in the table
>TIA
>Stuart
You just have record(s) where id is equal to "12345"
What you want as a result from that query?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.