• You probably need a full outer join.

    Also check the first link in my signature on how to ask questions on forums.

    It will make life easier for people trying to help you.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP