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

--- Sandip Bhattacharya <[email protected]> wrote:

> On Thursday 09 Sep 2004 10:11 am, Pankaj Kaushal
> wrote:

> 
> There is no c.id, d.id .... there are no primary
> keys in b,c,d.
> 
> Think of A(aid, aname, aaddress) as a table of
> people. And B a table of 
> languages that the person speaks. Assume there is a
> table 
> LANG(langid,langname). Then B has the structure
> (aid, langid), and for every 
> aid, there can be multiple rows in B.
> 
> Similarly, C,D are other table of attributes for the
> persons in A.
> 
> The search criteria specifies a particular
> combination of all attributes, so 
> the criteria is definitely an AND.

Hi! Sandip,

 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.

Regards
VK


=====
I was born Intelligent, but EDUCATION Ruined me.



Disclamer
The facts expressed here belong to everybody, the opinions to me. The distinction is yours to draw...


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail