I need to develop a join that can get me data from the 20K tables onto my 30K tables. I can't use a UNION to pull in the data because then I'll get duplicates.
On another note. Since the 20K tables are for the sub ledgers (still learning these terms so forgive me if I call them by the wrong names), then does that mean that all the transactions in the 20K tables should be encompassed in the 30K tables? I'm facing a situation where I believe that there is a record in my 20K table that isn't in the 30K table.
Lastly, do 20K tables have a history table?