RuralGuy AWF VIP Local time Today, 13:57 Joined Jul 2, 2005 Messages 13,825 Feb 12, 2008 #21 I believe Allen's link talks about the DISTINCT (DISTINCTROW) predicate.
G geraldcor Registered User. Local time Today, 20:57 Joined Jan 26, 2004 Messages 145 Feb 12, 2008 #22 Getting rid of DISTINCTROW doesn't do it. I have a feeling it is not query specific.
G geraldcor Registered User. Local time Today, 20:57 Joined Jan 26, 2004 Messages 145 Feb 12, 2008 #23 Maybe I should add this. I am using MySQL as the backend with the ODBC connector driver.
RuralGuy AWF VIP Local time Today, 13:57 Joined Jul 2, 2005 Messages 13,825 Feb 12, 2008 #24 What happens if you change your Join from a RIGHT Join to an INNER Join?
G geraldcor Registered User. Local time Today, 20:57 Joined Jan 26, 2004 Messages 145 Feb 12, 2008 #25 That didn't work either. Thanks for hanging in there with me so far.
RuralGuy AWF VIP Local time Today, 13:57 Joined Jul 2, 2005 Messages 13,825 Feb 12, 2008 #26 It definately could be something to do with MySQL with which I have no experience. Sorry. Maybe a MySQL guru will drop by.
It definately could be something to do with MySQL with which I have no experience. Sorry. Maybe a MySQL guru will drop by.