On 9/29/19 12:40 PM, stan wrote:
I have a table that consists of 3 columns.

vendor_key
mfg_key
preferred (boolean)

The idea is that a given vendor is the vendor we want to use for each
manufacturer for a given project.

I need to constrain such that  only on row of mfg, vendor and project can
be set to TRUE.

Where is the project id?


I would be interested in seeing other peoples approaches on this, also.

Any thoughts?



--
Adrian Klaver
adrian.kla...@aklaver.com


Reply via email to