Which join is best when combining two tables with multiple common fields
I have two tables and first table has A, B, C, D ,E as common with the second table A, B, C ,D, E.
I have to create a logical link between the two tables . What is the script to create this logical link.
AND should a Join be used to link these tables - what is the best join used to achieve this - is the best solution an Outer join as it will consider rows from both tables.
Not sure, Why Link Table table concept needed here. When we have common fields it merge into single table .
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
The business needs and nature of the data will determine whether you should join, concatenate or link these tables. There is no correct abstract/theoretical answer to your question.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
