> 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.
As result of insert command you have to receive stat info like this: ----------- Records: 100 Duplicates: 0 Warnings: 0 ----------- Which values do you have? Mikhail. ----- Original Message ----- From: "Menard, Inc. Information Systems" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 3:43 PM Subject: SQL Problems > 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 > --------------------------------------------------------------------- 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
