Create View AuthorTitles_Sync_Object as select authors.au_id, au_lname, au_fname, phone, address, city, state, zip, contract, author_titles =count(title_id) From authors,titleauthor where authors.au_id=titleauthor.au_id group by authors.au_id, au_lname, au_fname, phone, address, city, state, zip, contract GO