Help!! I'm completly confused with the below sql command:
insert into ur_rights select c.rc_id, u.uid, c.sys_id, r.theright, r.value from ur_rightchoices c, user_right r, ur_users u, ur_systems s where c.theright = r.theright and s.sys_name = r.system and s.sys_id = c.sys_id and upper(u.username) = r.user_name and r.user_name = "JGEISERT" When I run this comman I insert 253 records into ur_rights. If I runn the comman without the insert statement it returns 33,483 records. I even tried doing a select distinct ... and can up with the same record count. What am I over looking??? Thanks a bunch Jake --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
