CREATE OR REPLACE VIEW vCity AS select cityname, coname,usstateFK from City c, County co where c.countyFK=co.id;