I need to provide a pull-down that combines names from two different tables,
but I don't want to change the contents of either table. I want to combine
the the contents of a UnitPersonnel table and a NonUnitPersonnel table into a
Personnel_V view like this:
What is the appropriate way to get this result in Transact SQL? As a last
resort, I can produce the combined table using VBA in the MS Access front-end
file, but I would prefer to do it on the MS SQL Enterprise Server backside.
Thank you in advance for your help.
- Matt Lavery
You are responsible for everything you think, say, do, feel and believe.
That is all you are responsible for, and you are the only one responsible for
11. water effect