CREATE VIEW ownerprop (propertyno, ownerno, ownerfirstname, ownerlastname)
AS SELECT p.property_num, o.owner_num, o.first_name, o.last_name
From property_ p, owner o
where p.owner_num = o.owner_num
GROUP BY p.property_num, o.owner_num, o.first_name, o.last_name;

CREATE VIEW ownerprop (propertyno, ownerno, ownerfirstname, ownerlastname)
AS 
SELECT p.property_num as propertyno, 
       o.owner_num    as ownerno, 
       o.first_name   as ownerfirstname, 
       o.last_name    as ownerlastname
From   property_ p inner join owner o
where On p.owner_num = o.owner_num
GROUP BY p.property_num, o.owner_num, o.first_name, o.last_name

quote:

---

Originally posted by paintstripper

That code works great, but it still doesn't show the contents of the view after it has been created. How would I do this in the same query?
I can't get it to work at the moment, to look at the contents, I have to open a new query and type

Select *
From ownerprop;

Thanks,
Dan

---

select * from ownerprop