Regarding lookup

• angel41_23

  Old Hand

  Points: 359

  More actions

  March 8, 2009 at 12:56 am

  #129555

  hi

  i am new to sql server, i have gone through the lookup tool. .........

  but i am not getting where can we use this one......

  if there are 2 tables in the database which have FK relation between them, i need data from both tables,so i can use this lookup in ssis package......

  i am confused,, can anyone help me.......

  Thanks

• guptaopus

  SSCommitted

  Points: 1534

  More actions

  March 9, 2009 at 3:14 am

  #955838

  Yes,

  Exactly it does the same operation here you need to mention which column it should join(look) on

  eg: you need to mention unique key in that table

  select a from tablea a inner join tableb b on a.? =b.? and a.?=b?

  you just need to tick column a and connect ? coulmns which are unique