I need to perform a query which will return all records from the two views. "ViewOne" and "View2"
I can't use the SQL "UNION" statement because the table structures are not the same.
Can someone please help me. Here is the data returned from each view seperately. Notice
how there are duplicate records in the first view beause of different email addresses.
Also in the second view there are duplicate records because of the phone number.
SSNumber Name Age Email
333-33-22 Bob 22 firstname.lastname@example.org
235-27-11 Amy 33 email@example.com
923-43-44 Kim 44 KD@more.com
923-43-44 Kim 44 kimGirl@champ.com
SSNumber Name Coun
View Complete Post