Sinisa Milivojevic wrote:
> Nick de Voil writes:
> > I am running MySQL 3.23 on Windows 2000.
> >
> > I have a SQL statement which looks fine to me, although it does reference
> > the same table twice.
> >
> > Here it is:
> >
> > SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users
Nick de Voil writes:
> I am running MySQL 3.23 on Windows 2000.
>
> I have a SQL statement which looks fine to me, although it does reference
> the same table twice.
>
> Here it is:
>
> SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u,
> raw_data d, raw_groups g, raw_groups
Yes, MYSQL allows the same table to be aliased twice or more in a select
-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 12:35 PM
To: [EMAIL PROTECTED]
Subject: Same table aliased twice causes infinite loop
I am running MySQL 3.23 on
I am running MySQL 3.23 on Windows 2000.
I have a SQL statement which looks fine to me, although it does reference
the same table twice.
Here it is:
SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u,
raw_data d, raw_groups g, raw_groups gg WHERE u.forename = d.forename AND
u
