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?
Thanks