sql语句如下: select b1.l1, b2.l2 from b1 inner jion b2 on b1.l3 = b2.l3 系统提示 select b1.l1, b2.l2 from b1 inner jion b2 on b1.l3 = b2.l3 * 命令未正确结束 这是怎么回事啊,我看网上的sql都是这么写得啊。 顺便问问,内联,外联时怎么回事? 谢了先
by newman_maton - Oracle - 2004-03-11 10:46:54 阅读(1878) 回复(4)
表A记录如下:aID aNum1 a200501112 a200501123 a200501134 a200501145 a20050115表B记录如下:bID bName1 20060324012 20060324023 20060324034 20060324048 2006032408 创建这两个表SQL语句如下:CREATE TABLE a aID int( 1 ) AUTO_INCREMENT PRIMARY KEY , aNum char( 20 ) ) CREATE TABLE b( bID int(...
MySQL支持下列用于SELECT语句的join句法: table_reference, table_reference table_reference [CROSS] join table_reference table_reference inner join table_reference table_reference STRAIGHT_join table_reference table_reference LEFT [OUTER] join table_reference ON conditional_expr table_reference LEFT [OUTER] join table_reference USING (column_list) table_reference NATURAL LEFT [OUTER] join table_ref...
在下表中 inner 的作用 SELECT * FROM tb_Employees AS E inner join dbo.fn_EmployeesInDept(\'shipping\') AS EID ON E.EmployeeID = EID.EmployeeID
本文转自: http://www.wellho.net/archives/2004/12/index.html#000158 MySQL - LEFT join and RIGHT join, inner join and OUTER join In a database such as MySQL, data is divided into a series of tables (the "why" is beyond what I'm writing today) which are then connected together in SELECT commands to generate the output required. I find when I'm running MySQL training , people often get confused b...
给个通俗的解释吧. 例表a aid adate 1 a1 2 a2 3 a3 表b bid bdate 1 b1 2 b2 4 b4 两个表a,b相连接,要取出id相同的字段 select * from a inner join b on a.aid = b.bid这是仅取出匹配的数据. 此时的取出的是: 1 a1 b1 2 a2 b2 那么left join 指: select * from a left join b on a.aid = b.bid 首先取出a表中所有数据,然后再加上与a,b匹配的的数据 此时的取出的是: 1 a1 b1 2 a2 b2 3 a3 空字符 同样的也...
我想问问在oracle817中支持inner join 么? 我得程序在oracle9i下运行正常,在oracle817中就不行,提示以下的sql语句 不正确:SELECT RO_SYSTEM.SYSID,RO_SYSTEM.UUID,RO_SYSTEM.SYSNAME,RO_SYSTEM.SYSDESC,RO_SYSTEM.CREATETIME,RO_SYSTEM.guestenable FROM RO_SYSTEM Where RO_SYSTEM.SYSID<>;0 AND RO_SYSTEM.SYSID in( SELECT RO_APPLICATION.SYSID FROM RO_APPMODULE, RO_APPLICATION WHERE RO_APPLICATION.APPID = RO_APPMOD...
表A记录如下: aID aNum 1 a20050111 2 a20050112 3 a20050113 4 a20050114 5 a20050115 表B记录如下: bID bName 1 2006032401 2 2006032402 3 2006032403 4 2006032404 8 2006032408 创建这两个表SQL语句如下: CREATE TABLE a aID int( 1 ) AUTO_INCREMENT PRIMARY KEY , aNum char( 20 ) ) CREATE TABLE b( bID int( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , bName char( 20 ) ) INSERT INTO a VALUES ( 1, 'a20050111' ) , ...
表A记录如下: aID aNum 1 a20050111 2 a20050112 3 a20050113 4 a20050114 5 a20050115 表B记录如下: bID bName 1 2006032401 2 2006032402 3 2006032403 4 2006032404 8 2006032408 创建这两个表SQL语句如下: CREATE TABLE a aID int( 1 ) AUTO_INCREMENT PRIMARY KEY , aNum char( 20 ) ) CREATE TABLE b( bID int( 1 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , bName char( 20 ) ) INSERT INTO a VALU...
假如有三张表,a,b,c 它们都有一个相同的字段serverid 这里有条查询语句 select a.xxx,a,yyy from a join b on a.serverid=b.serverid join c on a.serverid=c.serverid where ....... 请问以上的查询语句意思是”找到表a,b中有相同serverid的记录,并把这些记录跟表c的serverid字段比较,查询出相同记录的条目吗?“还是”找到表a,b中有相同serverid的记录,并把表a中的serverid和表c中的serverid字段相比较,找到和表c中server...