Select matching database rows - select all columns

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)