Lookup join vs Ansi join

Which is better? Lookup join or Ansi join?

I have three document type , A , B and C
I want to join A and C , but its it not possible to use lookup join so I want use ansi join , But If I join A and B and join with C , I can use lookup join

In large scale , which approach is better?

  • A ansi join C
  • A lookup join B lookup join C

Use ANSI JOIN. It is standard