msyql query problem, help please


#1

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


#2

Everything you need to answer this yourself is at this site http://sqlcourse2.com/ . If you need some of the basic stuff first go here http://www.sqlcourse.com/ . 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.