re: how am I missing this key

2005-11-21 Thread SGreen
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

re: how am I missing this key

2005-11-21 Thread James Black
-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