G
Guest
I would like to do the following select statement but to strip the duplicates,
this is what I have so far
SELECT E.ExhibitorID, E.ExhibitorShortName, E.ExhibitorName,
ES.ExhibitorShowID
FROM Exhibitors E
LEFT OUTER JOIN ExhibitorsShows ES ON E.ExhibitorID = ES.ExhibitorID
I have tried distinct and that did not work
Any ideas on what I am doing wrong?
this is what I have so far
SELECT E.ExhibitorID, E.ExhibitorShortName, E.ExhibitorName,
ES.ExhibitorShowID
FROM Exhibitors E
LEFT OUTER JOIN ExhibitorsShows ES ON E.ExhibitorID = ES.ExhibitorID
I have tried distinct and that did not work
Any ideas on what I am doing wrong?