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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================