>Are you saying that your query will always return just one row per each Numero? BTW, did you have a chance to run your query as a MERGE command? I am thinking it may return an error in your case that UPDATE FROM will not return (see Erland's blog). So, I am curious in the outcome.
Well, I need to keep it ANSI SQL, so I do not want to go too much with proprietary stuff. What I have right now seems to work based on my analysis I did from some results. Basically, we have a Menu table which includes a bunch of check marks for privileges. That is one way a user can be given access to the menu. But, from that, if he has, he might be restricted from a secondary table. That is the first SQL. The second SQL is where we give access to a user to a menu, which he doesn't have access by default, by adding an entry in a secondary table.