On Fri, Aug 16, 2002 at 16:15:57 +0100,
Gary Stainburn <[EMAIL PROTECTED]> 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 jus
Hi all,
I've got some fuel pumps, each of which sell a number of fuel grades - one
nozzle per grade, each nozzle connected to a specified tank containing that
grade.
I can define the tanks, the pump numbers, and the pump grade/nozzle config
using the tables below.
create table grades ( -- di
