How do you search through multiple tables?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 20 Feb 2003 11:18:33 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703547E03@lnewton.leeds.lfs.co.uk>

Hi Rene,

... but it wasn't bad for a first attempt :o)

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: Rene Nyffenegger [mailto:rene.nyffenegger_at_gmx.ch] Posted At: Wednesday, February 19, 2003 6:14 PM Posted To: server
Conversation: How do you search through multiple tables? Subject: Re: How do you search through multiple tables?

Norman

If a table has multiple columns to be searched, it will entail multiple table scan. I'd suggest to do one table in one go like so:

<SNIP> Received on Thu Feb 20 2003 - 05:18:33 CST