Re: Question on creating table that has recursive(self-referential) foreign key

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0203202019.2e4ac308_at_posting.google.com>...
> HI all,
> I need your help on Creating table that has recursive (self
> referential ) foreignkey. and it would be better if you can give me a
> real life example.
>
>
> Advance Thanks
> Sohel

Sounds like a school assignment. In that case, look up the definitions of foreign key and primary key and figure it out from there.

I will give a real life example: an address is next door to another address. (provides conectedness when numeric portion is not incremental, i.e. the nubers don't increase by 1 or even a constant number from house to house).

HTH
 Ed

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com