Joining between Tables

[hemachandran]

Hi Everyone,

I am working in finance Application.

I have three tables

Vend Packing Slip Jour

Vend Packing slip Trans

Vend Trans

I want to join these three tables. I dont  knew the linking table to join these tables..

Can anyone have idea for joining these tables.

thanks in Advance..

[marcus_malinow]

Hi,

you'll need to provide a bit more information, such as a field list of each table, if you want a detailed answer.

Are these all different types of fact record? If so there are two common approaches - either concatenation of link tables. If you search you can find detailed descriptions of each of these approaches.

Marcus

[dathathreya]

by using Left Join we can join three tables

[dathathreya]

Plz go through this link .hope it will help u.

http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/

[hemachandran]

Hi,

Thanks for ur response..

I am in need of technical terms of linking tables in database in finance Application..