Re: tricky SQL SELECT - help!

Norman Dunbar wrote:

> This is horrible !
>
> SELECT NAME FROM people
> WHERE INSTR((SELECT people_ids FROM pets WHERE pet =
> 'Rat'),';'||TO_CHAR(ID)||';
>
> NAME
> --------------------------------------------------
> John
> Wilma
> Dick
> Mike
>
> 4 rows selected
>
> Can you imagine having to do that with a join to another table on the
> poeople id ?
> Yeuch !
>
>
> Cheers,
> Norman
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Norman Dunbar
> Posted At: Friday, January 31, 2003 4:11 PM
> Posted To: server
> Conversation: tricky SQL SELECT - help!
> Subject: tricky SQL SELECT - help! (PS)
>
> PS. And having done that, find me a list of all the people who keep rats
> .........
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------

Can you imagine trying to do an update or delete?

Daniel Morgan Received on Fri Jan 31 2003 - 11:23:13 CST