Posted by J.O. Aho on 12/23/06 13:32

Stef wrote:
> I was wondering if it is possible to load the values of a ENUM out of
> antoher table.
>
> Example:
>
> Table 1
> id Colors
> 1 A
> 2 B
> 3 C
>
> Table 2
> id car color
>
> Would it be possible to set 'color' to an ENUM type and load the different
> values of color out of table 1?

Was it this you had in mind?
http://dev.mysql.com/doc/refman/5.0/en/join.html

Works pretty in the same manner/syntax on most real SQL databases.


--

//Aho

[Back to original message]