On 9 Jan 2004 at 15:33, Roger Baklund wrote:
> * Rory McKinley
> [...]
> * Odhiambo Washington
> >> I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
> [...]
> > I can't see what is throwing the syntax error..p'raps I am just
> > being dense.
>
> "Note that INNER JOIN synta
* Rory McKinley
[...]
* Odhiambo Washington
>> I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
[...]
> I can't see what is throwing the syntax error..p'raps I am just
> being dense.
"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17
on. The same i
On 9 Jan 2004 at 16:48, Odhiambo Washington wrote:
> * Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote:
> > On 7 Jan 2004 at 11:04, Odhiambo Washington wrote:
> >
> > >
> > > Hello,
> > >
> > > I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
> > >
> > > SELEC
* Rory McKinley <[EMAIL PROTECTED]> [20040109 13:21]: wrote:
> On 7 Jan 2004 at 11:04, Odhiambo Washington wrote:
>
> >
> > Hello,
> >
> > I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
> >
> > SELECT popbox.local_part, popbox.password_hash, popbox.domain_name,
> CONC
On 7 Jan 2004 at 11:04, Odhiambo Washington wrote:
>
> Hello,
>
> I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
>
> SELECT popbox.local_part, popbox.password_hash, popbox.domain_name,
CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain
USING (do
Hello,
I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
SELECT popbox.local_part, popbox.password_hash, popbox.domain_name,
CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING
(domain_name)
I would like to make this query run on a 3.23.58 ser