wait, now I'm stuck again.
The query I'm doing has several ANDs for each company.
So, I tried this, as a test:
SELECT users.company, users.fname, users.lname, states.short_name, users.email FROM users, states WHERE (users.company = 'pamchess' and states.stid = users.state) AND (users.company = 'hess' and states.stid = users.state);
however, this returns a zero result.
Can you help?