I concur with Remi... a simple polling job is not going to be any load on the server at all.  We have a couple that run using the undocumented but...

If the tables already exist, there should be foreign keys in the child tables (the "many") that point to the parent tables (the "one").

If not, then, as Sreejith suggested, you...

You can fool around with user names, if you want, but those can always be tricked especially when users make the mistake of sharing logins...

If your Windows network is setup...

This should do the trick... the SELECT is where the rubber meets the road... the rest of the stuff is just setting up for the demo of the SELECT...

--===== If...

Actually, I've resurrected some old code I was working on to make a WebTask that would make some pretty output... the output does not yet list the primary or other...

Not a problem... thanks for the feedback.

Nope... new columns always get added to the "end" of the table if you use just an ALTER.

However, if you go into Enterprise Manager to design the table (add the...

By the way (drum roll, please), congrats on the more than 7000 posts you've made

True enough... you won't be making a view out of it, for sure

Bingo!!

Yep... and you've nailed the key to it... exclusive access... now, what table(s) will a developer ALWAYS have exclusive access to?

Yap... we've all written "those"... see the update I just posted to my previous message...

Sure, Remi... thanks for the interest...

Personally, I think triangular joins should never be used because it's an absolutely insane form of RBAR (a "Modenism" for "Row By Agonizing Row").  Here's an example...