We are on Postgresql 9.7
I have two tables.
Table-1 has about 100 codes. As an example,
My table-2 has a code field, which needs to only allow a subset of the codes from Table-1.
Example: Table-2 can only have values 'M' and 'R'.
Is it possible to create a constraint or something?