Re: help with crosstable SEARCH

2001-07-17 Thread Werner Stuerenburg
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

help with crosstable SEARCH

2001-07-17 Thread Jaime Teng
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