Join and Keep

[#1]

Hi All,

When and Where we will use Keep and Join?

Please explain answer to my question

Regards

Sharath

[mayankraoka]

Hi Sharath,

This may help you..

Understanding Join, Keep and Concatenate

Regards,

Mayank

[MK_QSL]

Keep

When you want load data based of one table based on some field/value from another table, but don't want these two tables to join..

Keep

When you want load data based of one table based on some field/value from another table and also want to join and make a single table..

Understanding Join, Keep and Concatenate

[Anonymous]

Go through these threads:

Understanding Join, Keep and Concatenate

Difference between keep and joins with example

Hope this will help!!

[mohammadkhatimi]

Hi...

Hope this will helps u...!!

Regards,

Mohammad