Well, you have to tell MySQL somehow how to connect those two
tables. You may want to check the syntax for JOINS to understand
what's going on.
> I have two tables:
> whenever I tried doing this select, mysql would hang
> indefinitely trying to resolve it or at least took
> t long I would r
Hi,
I have two tables:
whenever I tried doing this select, mysql would hang
indefinitely trying to resolve it or at least took
t long I would rather shutdown the whole machine.
SELECT m.username, m.class, u.password
FROM masterlist m, user u
WHERE m.class <> '' LIMIT 20;
However, when I in