Re: Re: [LIP] An SQL question about using multiple tables

On Thursday 09 Sep 2004 1:14 pm, Sandip Bhattacharya wrote:
> On Thursday 09 Sep 2004 11:07 am, vivek khurana wrote:
> > --- Sandip Bhattacharya <[email protected]> wrote:
> >
> >  Can you specify the problem in full, it will be
> > helpful in writing down the query.  As 3 tables dont
> > have primary key you might have to resolve to other
> > techniques.
>
> Giving an example for the B table, which I call an attribute table. A can
> have one or more attributes. B stores the language attribute.
>

Ok. I think I got it together. I created temporary tables for all teh 
attribute searches, and then inner joined them one after another for the 
AND'ing proces.




- Sandip
-- 
Sandip Bhattacharya    *    Puroga Technologies   *     sandip-/[email protected]
Work: http://www.puroga.com        *         Home: http://www.sandipb.net

PGP/GPG Signature: 51A4 6C57 4BC6 8C82 6A65 AE78 B1A1 2280 A129 0FF3

Disco oil bussing will create a throbbing naugahide pipeline running
straight to the tropics from the rug producing regions and devalue the dollar!