View Single Post

  #3 (permalink)  
Old 11-15-2005
Christian Kirsch
 
Posts: n/a
Default Re: key on more table

Jerry Stuckle wrote:
> myname@yahoo.it wrote:
>
>>Hi,
>>do you know how can I declare a key on more tables?
>>
>>For example, if I have the table TABLE1 and the table TABLE2, every one
>>with a field called key, how can OI declare in mysql that the key is
>>composed of TABLE1.key AND TABLE2.key?
>>
>>Thanks a lot
>>Marco Righi
>>

>
>
> Macro,
>
> You can't. The purpose of a key is to uniquely identify a row in a
> single table.
>


s/uniquely//
Reply With Quote