updating views - preserved keys - confusion

HiYa

if I have 2 tables

Table 1
COL1 PRIMARY_KEY,
COL2 PRIMARY_KEY,
COL3,
COL4 Table 2
COLA PRIMARY_KEY,
COLB,
COLC and declare a view

View 1
SELECT COL1, COL2, COLA
from table1, table2
[Quoted] where COL1 = COLA;

are both tables preserved key tables??

I want to write SQL to update rows in either table depending on the values that are changed

thanks

--

See Ya
(when the bandwidth gets better ;-)
Chris Eastwood                            Please remove undies for reply
Photographer, Stunt Programmer            WWW -> www.powerup.com.au/~cjeastwd/
Motorcyclist and dingbat