The legal department needs to send a blast e-mail to all Employers, Members and Carriers who reside or do business in the state of Ohio. Create a UNION query that will build a result set with a complete list of Ohio contacts. Include the contact name, e-mail addresses, and a column that identifies the rows table of origin: Member, Employer or Carrier. For example insert an'M' for members, 'E' for employees and a 'C' for carriers. Order the unioned data by contact name.

INSTRUCTOR PROVIDED HINT:

I use some column formats so that this fits nicer on the page... for example. column cname format a20 truncate; column email format a20 truncate; column ctype format a10 truncate; also -- to build in the column to identify where the data comes from - just add another column on the SELECT line but the data won't come from the tables -- instead create a new column populated with your own data with a text value for example -- an entry : 'carriers' as contact type CNAME EMAIL CTYPE -------------------- -------------------- ---------- Ann Bailey abailey@bcbs.com Carrier Jack James jj33@yahoo.com Employer Nick Jacione jacione.nick@nationw Carrier Teresa Keefe imafriend@hotmail.co Member