まとめ 今回は、MySQL Workbenchを使ってSELECTした結果をSQLに変換してみました。 SELECTした結果をそのままSQLにしたいというワークロードはあまりないようで、発生した場合にどうしたらいいか悩んでしまうこともあると思います。

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Reading and Updating Data with the SQL Procedure In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data ...

Starting with JDBC driver 12.10, the following resultset will be null and seems to ignore the select statement at the end. This is a regression from previous JDBC driver versions before 12.10. It is ...

Non-SELECT SQL statements can be saved to and executed from the Result Manager window. See Saving SQL Code or Output and Doing More with Results for information.

I'm honestly not sure how well the list of rows will concatenate like that into a single SQL statement for sp_executesql. If it doesn't, you'll have to write a cursor for the SELECT ...