MySQL Join table and count distinct users with no reference in another table

[Mr.c0dy]

I am trying to count users that are NOT referenced in another table... Right now, I have something along the lines of this:\[code\]SELECT COUNT(DISTINCT u.id) FROM users u INNER JOIN orders o ON o.assigned!=u.id;\[/code\]However, it's returning an invalid value. Any suggestions?Thank you!