Select matching database rows - select all columns

2

The "Select matching database rows" creates a temporary table in the target database, exports specified columns into it, then executes SELECT ... WHERE ... EXISTS statement, then deletes the temporary table. The same logic can be done using regular actions in EasyMorph:

  1. "Database command" (to create a temporary DB table)
  2. "Export to database"
  3. "Import from database". Here you can use a custom SQL statement with SELECT * WHERE ... EXISTS
  4. "Database command" (delete the temporary DB table)