James Black <[EMAIL PROTECTED]> wrote on 11/21/2005 09:39:32 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Using mysql 5.0.15 my query gets a result of "Unknown column 'i.rid' in
> 'on clause'"
>
> There is actually a complete query, but this is a snippet, as the
> selects with subqu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Using mysql 5.0.15 my query gets a result of "Unknown column 'i.rid' in
'on clause'"
There is actually a complete query, but this is a snippet, as the
selects with subqueries I don't believe will cause the problem. When I
changed c.rid=i.rid to c.rid