Tables link by Stored Procedure

  • I need to Link two tables by SP

    I need to Link Field F1 of Table T1 with F2 of table T2




    My Blog: http://dineshasanka.spaces.live.com/

  • What do you want to accomplish exactly? Maybe give an example.

    Just to select the fields use

    SELECT T1.<fields>, T2.<fields>
    
    FROM T1 INNER JOIN T2
    ON T1.F1 = T2.F2
  • Thankx for the reply.

    But what I need is to add a reletion ship between two tables by a SP




    My Blog: http://dineshasanka.spaces.live.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply