On Fri, Aug 16, 2002 at 16:15:57 +0100, Gary Stainburn <gary.stainburn@ringways.co.uk> wrote:
>
> I only want the insert to work if prpid matches pgpid and prnozzle matches
> pgnozzle.
There are several typos in your sample that make it hard to know for
sure what you want to do. However I suspect you just want to add a
foreign key clause to your table definition. These can refer to more
than one column (unlike references). My memory is that you need a matching
unique index defined for the table you are referencing.