Is it possible to define a complex view in a query, then display the contents in the same query? I am having trouble making it work.
The view is as follows:
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;
What would I put after the view to make it show?