I want to know the exact difference between join and Keep join .I know the usage of both but I want to know in which situation I use Join and Keep join .
If I use join what is the advantage/disadvantage with respect to Keep joins.
Please help me to understand this functionality how it works.
Thanks in Advance.
well it depends on your data model, if it is better to combine two tables using join or keeping the two tables separated but having only the linked data.
so you should consider the size of the table that you want to join and whether it is a linked table or not, usually in the case of a linked table you don't want to join it.
If u want to make two different tables into one in your data model with one common key then u can use join.
But if u want to keep two tables as it is and want a relation(Join) between them then you can use keep.