Ok..so if am not wrong then dealer code is in the first table and you are looking for all the records in second table.
If this is the case then I am confused by your statement.
As the extra records do not belongs to any dealer code these are records(having dealer code as NULL) which do not found any match in first table.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂