transformations:selectdbrowsbykeys
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:selectdbrowsbykeys [2017/05/02 23:10] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Select matching database rows ===== | ||
+ | |||
+ | Selects rows from a database table where a combination of key fields matches a combination of key fields in EasyMorph table. | ||
+ | |||
+ | Under the hood the transformation creates a temporary table in the target database, uploads key field combinations into it and performs SELECT..WHERE ..EXISTS statement. After the statement is executed the temporary table is deleted. | ||
+ | |||
+ | **Use cases** | ||
+ | |||
+ | This transformation can be used for // | ||
+ | |||
+ | Another use case is // | ||
+ | |||
transformations/selectdbrowsbykeys.txt · Last modified: 2021/04/08 23:49 by craigt