Here are the solutions to the homework problems I sent out. Compare my queries with yours. If they’re different, and you’d like some explanation on why they’re different. Let me know. I’ll be happy to explain any differences with you.
1. Give me a list of all the first and last names in both tables. If the person exists in both tables I do not want to see the name duplicated. If they are duplicated in each table separately, I don’t mind the duplication. Order the list by last name, a to z.
2. Repeat the last query, this time I do want to see duplicates.
3. Show me the first and last names that are in both tables.
4. Show me all the first and last names from person.contact that are not in example.person.
5.Insert one record from person.contact that is not in example.person. Do this without using a JOIN statement.
Again, if you have any questions, please let me know!