MIS-605: Topic 6 DQ 2 (Latest Update) Verified and Rated A+

MIS-605: Topic 6 DQ 2 In the topic assignment, the two temporary tables (#MyPriceHistory and #MySalesOrderDetailbyDate) cannot be joined in their current state. Explain why this join is not possible. Discuss what you think is missing in order to make a join work and propose the solution to your peers in the Main Forum. Provide two peers with feedback about the potential answers to this question and justify why you think one answer might be more correct than others that are proposed. The key of joining the two temporary tables mentioned is finding what the similarities are between the tables, so that they can be joined together into a new table if it is possible. The main similarity that would create a new table with the join information between the two tables, would be the similarity of the primary and foreign keys of the tables. Alas, the keys from the two tables are not similar, which would mean that these tables cannot be joined together through this way. A possible option to join the two tables using the keys would be to use a third table that has keys that are in both of the other two tables to join them together. The third table acts as the bridge between the other tables to join them together.