Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Awaiting solution.
Not sure, Why Link Table table concept needed here. When we have common fields it merge into single table .
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.