> > >Maybe if you show the table source (stripped for content of course) and
> > >attempt to explain what you are trying to accomplish. I have an idea what
> > >you are trying to do but I'm not very good at reading minds so I might be
> > >wrong. ;)

Table structures :

GRADES

CREATE TABLE "GRADES"
(
"GRADE_NUM" SMALLINT,
"DESCRIP" VARCHAR(20),
"BUDGET" DOUBLE PRECISION
);

NOZZLES

/* Table: NOZZLES, Owner: SYSDBA */

CREATE TABLE "NOZZLES"
(
"NUMBER" SMALLINT,
"NOZZLE_ID" SMALLINT,
"PUMP" SMALLINT,
"TANK" SMALLINT,
"CMTOTALISR" DOUBLE PRECISION,
"CLTOTALISR" DOUBLE PRECISION,
"SMTOTALISR" DOUBLE PRECISION,
"SLTOTALISR" DOUBLE PRECISION,
"MTOTALISR" DOUBLE PRECISION,
"MSOLD" DOUBLE PRECISION,
"LSOLD" DOUBLE PRECISION,
"PPU1" DOUBLE PRECISION,
"PPU2" DOUBLE PRECISION,
"PPU3" DOUBLE PRECISION,
"PPU4" DOUBLE PRECISION,
"COST_PRICE" DOUBLE PRECISION,
"TAG_ADRES1" VARCHAR(5),
"TAG_ADRES2" VARCHAR(5),
"TAG_TYPE1" SMALLINT,
"TAG_TYPE2" SMALLINT,
"RATING" DOUBLE PRECISION,
"MDIVISOR" SMALLINT,
"LDIVISOR" SMALLINT,
"PDIVISOR" SMALLINT,
"PULSES" DOUBLE PRECISION
);

TANKS

CREATE TABLE "TANKS"
(
"NAME" VARCHAR(10),
"NUMBER" SMALLINT,
"SVOLUME" DOUBLE PRECISION,
"CVOLUME" DOUBLE PRECISION,
"GRADE" SMALLINT,
"ALT_GRADE" SMALLINT,
"TANK_HT" DOUBLE PRECISION,
"MAX_VOL" DOUBLE PRECISION,
"TG_ADDR" VARCHAR(3),
"PROD_CODE" VARCHAR(6),
"TAX_INDEX" SMALLINT,
"COST" DOUBLE PRECISION,
"MIN_VOLUME" DOUBLE PRECISION
);





[Non-text portions of this message have been removed]