Home Forums SQL Server 2005 SQL Server 2005 General Discussion JOIN on two fields RE: JOIN on two fields

  • June 30, 2009 at 10:21 am

    #1017740

    select

    *

    from

    TableA ta

    inner join TableB tb

    on (ta.Col1 = tb.Col1

    and ta.Col2 = tb.Col2)

    hth