Home Forums SQL Server 2008 T-SQL (SS2K8) How to combine two tables when one table is in different database and this table will determine the value to be shown on the first table. RE: How to combine two tables when one table is in different database and this table will determine the value to be shown on the first table.

  • January 14, 2013 at 5:14 pm

    #1577119

    Hello Sean. Thank you for the sample query, it works just fine (with some minor modifications). Awesome! 🙂

    I apologize to you (and to the readers) for making my aliases so short, actually I am just in a "hurry" that is why I used short aliases. In my query here, I (really) used full table abbreviation. (silly me). :crazy: :w00t: 😀

    Just one last thing, how would I add an additional column called [font="Courier New"]CameFromArchive[/font] so that the database administrator would determine what [font="Courier New"]CtrlNo[/font] came from the archive table (0-NO 1-YES)?

    Thank you so much and more power!

    Respectfully Yours,

    Mark Squall

    ________________________________
    "Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20