Is it possible to validate a specific column on insert from one table to another using a reference table?.
Reference Table is as follows:
LineID INT ProdCode VARCHAR (10)
Source table and target table both have column ProdCode VARCHAR (10)
If the ProdCode does not exist in the Reference table, then the insert to the target table should fail.
Any help would be appreciated.