I have not, however I rarely use explicit joins (left / right /
inner / outer).
I also only ever SELECT DISTINCT when I use joins, as it stops this
from happening.
My suggestions is to use a simple JOIN in this case, unless your
idxfield order rally matters.
- Tom
On 05/03/2007, at 9:23 AM, Todd Fantz wrote:
> Not sure if this should go to some beta list?/place?
>
> I am using the same routine in two apps... one built with RB5.5 and
> the old MySQL plugin and one with 2007r1 and the new plugin...
>
> The old one returns what I expect (six records) from this join
> statement
>
> nrs.sqlselect("select * from rundownitems_t left join scripts_T on
> rundownitems_t.rdiscriptid=scripts_T.scriptid where
> rundownitems_t.rdparentid='4' order by rundownitems_t.rdorder")
>
>
> The new one returns six records but the joined (scripts_T fields)
> info is duplicated (I get the same information twice)
>
> If I use this select statement in MySQL utilities I get the expected
> results.
>
> I am going to try and make an isolated example, but has anyone seen
> this before or is there something about my syntax that I need to
> change with the new plugin?
>
> Thanks,
>
> Todd Fantz
> [EMAIL PROTECTED]
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
