hey everyone. i have 2 tables, one with car makes/models and the another with reviews for the makes and models. i am trying to join both tables but i keep getting duplicates. this is my code. select e.[Model Year],e.[Division Name],e.[Model ID],e.[Model Name],e.[Model Strengths],e.[Model Changes],e.[Model Value],e.[Model Overview],m.[VIF],m.[StyleID] from NSReviews e full outer join NSmakes m on (e.[Division Name] = m.eMake and m.eModel = e.[Model Name]) Code (markup): the only Related rows are the makes & models thanks.
is the [Division Name] suppose to be join with m.eMake? e.[Division Name] = m.eMake doesn't seem right