Three tables:
computers (Describes computers)
users (Describes users)
comp-user-link (Links users to computers in a 1 user to many computers relationship)
Could someone offer advice on how to construct a select statement to show which users aren't in the comp-user-link table? Sort of the reverse of this:
select * from comp-user-link, users where users.user_id = comps_users_link.user_id
Basically, I'm trying to see which users aren't currently linked to a computer.
As always,
Thanks!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
