 create view v1 (auth,title,cost) as select tblauthor.aut_name,tblbooks.title,tblbooks.cost from tblauthor,tblbooks,tblpublisher,tblbook_auth where tblpublisher.p_name='sun' and  tblbooks.p_id=tblpublisher.p_id and tblauthor_a.id=tblbook_a.id;

 create view v1 (auth,title,cost) 
as select tblauthor.aut_name,tblbooks.title,tblbooks.cost 
from tblauthor,tblbooks,tblpublisher,tblbook_auth
 where tblpublisher.p_name='sun' and tblbooks.p_id=tblpublisher.p_id
 and tblbook_auth.b_id = tblbooks.b_id 
and tblauthor.a_id=tblbook_auth.a_id;

