The Database join step that you learned to use in the previous recipe is quite powerful and has several advantages over the simple Database lookup step. There is a still more powerful step for searching in a database: The Dynamic SQL row step. This recipe explains to you its capabilities and shows you how to use it.
In order to let you compare the different options for searching in a database with ease, we will work with an example similar to that you saw in the previous two recipes: we will work with the Steel Wheels sample data. You want to look for the following products:
Aston Martinin their description
Ford Falconin their name and with scale ...