Home Forums SQL Server 2005 SQL Server Newbies one-to-many relationship select query RE: one-to-many relationship select query

  • July 30, 2010 at 2:22 pm

    #1200543

    SELECT *

    FROM TABLE_A AS A

    LEFT JOIN TABLE_B AS B ON A.A_ID = B.A_ID

    [/code]

    Is that what you're looking for?