On Monday 03 February 2003 13:31, Ciprian Trofin wrote:
> I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
[skip]
> Now, the problem:
>
> This doesn't work:
> SELECT R.id, U.user FROM ring R, users U WHERE R.user = U.id;
>
> id user
> -
> 4 0
You have some unnecessary indicies.
What happens if you remove them?
Ciprian Trofin wrote:
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE
