Re: [Phpwiki-talk] linking scheme and markup

[Jeff D. <da...@da...>]

On Wed, 07 Nov 2001 13:19:24 +0000
"Reini Urban" <ru...@x-...> wrote:

> mysql 3.22.30 is too old. we are at 3.23.x
> remove USING(id) as Jeff sent you.

Though I don't think there's any fundamental reason we can't or 
shouldn't support mysql 3.22.30.

Tara/Steph: if you figure out anything, do let me know...

My current hunch is that the older mysql has a problem
specifically with the INNER JOIN ... USING(...) syntax
and that "LEFT JOIN ... USING(...)" would work fine.
I'd like some confirmation of that, though, before I act
on it.

Perhaps, for maximum portability, we/I should convert all
the joins to plain cross joins.  Instead of
  SELECT FROM x INNER JOIN y USING(id) WHERE ...
use the archaic:
  SELECT FROM x,y WHERE x.id=y.id AND ...

?