did I leave the DISTINCT clause in there?
if I did remove it. if not. i’ll have to figure out why its doing it on my end.
Did you see the fiddle?
this is probably the easiest.
do 3 letter searches (example “dri” no quotes)
it will produce duplicate error
(I took out the DISTINCT to show that it does doubles without it)
All of them are not giving duplicated however.
now that is odd - i get dupes on my end… so that link with a 3 letter search is providing single results??
here is a screenshot of what i get using “dri” for example
