2006/6/5, MySQL Nexeia <[EMAIL PROTECTED]>:
I face one problem with mysql4.0
I've two tables, one called company and the other called favorites. The
relation between those two tables is CO_ID on the company table and
MASTER_CO_ID on the favorites table. When I run the following query it works
f
Subqueries aren't implemented in 4.0 - only 4.1 and upwards support
subqueries.
Cheers
Andrew.
- Original Message -
From: "nambi c" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 22, 2004 10:31 PM
Subject: subquery problem.
> Hi,
>
> My server version : 4.0.18-max-n
Version 4.0 doesn't support subqueries.
In any event, your query would return all rows from
channels as long as there are any rows in users, which
I doubt is what you intended.
--- nambi c <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My server version : 4.0.18-max-nt
>
> I have created 2 tables 'chan
