Home Forums SQL Server 2008 SQL Server 2008 - General Joining Multiple matches from Right Table to 1 row of results RE: Joining Multiple matches from Right Table to 1 row of results

  • November 28, 2012 at 5:48 am

    #1563061

    Actually, I have a few thoughts that could get around this. Mainly via the use of a subquery that selects each distinct property and then JOINs to the other tables to pull up the remaining fields.

    Post your Table DDL and some sample data and I'll see what I can whip up that will help you out.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.