Home Forums SQL Server 7,2000 T-SQL JOIN PROBLEM RE: JOIN PROBLEM

  • April 1, 2004 at 2:45 pm

    #501524

    Something like below:

    From T1 (nolock)

    JOIN T2 (nolock) on cast(T1.ID as char(10)) = cast(T2.ID as char(10))

     

    I can't really help you more without the actual data types and some sample data.

    Signature is NULL