I'm trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep those records that were matched and then seek to join the unmatched records from my first join to my next table and vice versa. Can someone please help? Here is an example of what I'm writing but I'm sure I'm doing something wrong as I get no results. I'm thinking I need parenthesis somewhere here:
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!