Building an SQL JOIN command starts as a regular SQL SELECT command, but instead of specifying fields from just one table, you can specify fields from more than one table.
构建SQLJOIN命令时,开始仍是常规的SQL SELECT命令,但这里不是仅指定来自一个表的字段,而是指定来自多个表的字段。
The SQL SELECT command you produced is
这样您产生的SQL SELECT命令是
For this, you need to extend your SQL SELECT command using a JOIN.
为此,您需要使用一个JOIN来扩展SQL SELECT命令。
After you finish editing the command, right click on it and select Run SQL.
编辑完命令之后,右键单击它并选择Run SQL。
You can also define the shape of your select command, be it an SQL statement or stored procedure call, by either discovering the result set or manually defining the one or more returned result sets.
您还可以通过发现结果集或手工定义一个或多个返回结果集,来定义select命令的形式是一条sql语句还是存储过程调用。
In the DB2 Command Editor, enter the following SQL statement: select data from status_updates.
在DB 2CommandEditor中,输入以下sql语句:selectdata from status_updates。
The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.
通过视图存取的数据,实际上是通过标准的T - SQL查询命令构成的,而且可以来自许多不同的基础表,甚至其他视图。
SELECT is by far the largest and most complex command in SQL.
SELECT命令是至今为止SQL中最大最复杂的命令。
SELECT is by far the largest and most complex command in SQL.
SELECT命令是至今为止SQL中最大最复杂的命令。
应用推荐