1. computers 2. users 3. comp_user_link
This particular DB is used for inventory and tracking purposes. I think the table names are self explanatory. Computers has 'comp_id'... users has 'user_id' as their primary indexed keys. These keys are linked together in the comp_user_link table. A user may have more than one computer (For example, Bob may have a desktop and a laptop at the same time), but no computer may be linked to more than one user simultaneously (Bob and Tom should never have the same laptop at the same time).
Anyway, what I'd like to do is to find all 'user_ids' that aren't linked to a computer. Any tips on how to arrange a SELECT statement to do that?
Thanks,
Bart
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]