Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
by using Left Join we can join three tables
Plz go through this link .hope it will help u.
http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/
Hi,
Thanks for ur response..
I am in need of technical terms of linking tables in database in finance Application..