join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

[#1]

join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and  disadvantages?

pls  tell me

[ThornOfCrowns]

1) Please put your question in the body, rather than the title.

2) What has your research told you about JOIN and KEEP?

[#3]

Hi Manoj,

Just create two sample tables, and perform Join and Keep operations, then u will get some idea.

Tell me one thing, are u working somewhere or searching for a job.

[#4]

deniki brother

[avinashelite · Accepted solution]

Hi Manoj,

If the data is less we can use concatenation, but if the data is huge it will create lot of junk records which will increase the size of your application and effect the performance.

Join: Join will help you to filter out the records based on the common values  between the table concatenation will not do that eg LEFT, RIGHT joins etc

Please go through this attachment for more details

Regards,

@vi

[#6]

join and keep do the similiar activities but join merges the two tables and shown as a single table in table viewer.but keep shows as 2 tables in table viewer.

[cspindley]

if your wrote the pdf then thanks, you are a gent, if not then please pass on my thanks