msyql query problem, help please


entries (
entry_id int not null default 0 auto_increment,
user_id int,
entry text,
primary key(entry_name)

users (
user_id int not null default 0 auto_increment,
username varchar(100),
class_id int,
primary key(user_id)

I have these 2 tables, How could i do a mysql query to get the count(entry_id) from entries where the user_id column
IS NOT a valid user_id in the users table?



Everything you need to answer this yourself is at this site . If you need some of the basic stuff first go here . Reading both can only help you - and will go a long way.

If after you have read those and tried to create your own SQL with problems, come back and we will be happy to help you fine tune it.