Hi,
you can try with subquery or left join:
(easiest, but not all version of mysql support this... )
SELECT * FROM users u WHERE userid NOT IN (SELECT userid FROM buildings)
(this instead may work fine...)
SELECT u.* FROM users u LEFT JOIN buildings b ON u.userid=b.userid WHERE b.userid IS NULL
for more info try www.mysql.com/subqueries
see you
