互联网服务数据库 SQL

left join 子查询报错

问问子查询left join报错的问题,select * from a left join ( select b.id1,c.c1 from b,c where b.id2 = c.id2 ) f on a.id1 = f.id1语句执行报语法错误,请各位大侠帮忙看看怎么修改,谢谢 create table a( id1 integer, a1 integer )...显示全部

问问子查询left join报错的问题,
select * from a left join ( select b.id1,c.c1 from b,c where b.id2 = c.id2 ) f on a.id1 = f.id1
语句执行报语法错误,请各位大侠帮忙看看怎么修改,谢谢

 create table a(
 id1 integer,
 a1 integer
 );
 insert into a values(1,1);
 insert into a values(2,2);
 insert into a values(3,3);
 insert into a values(4,4);
 insert into a values(6,6);
 insert into a values(7,7);

 create table b(
 id1 integer,
 id2 integer,
 b1 integer);
 insert into b values(1,1,1);
 insert into b values(3,3,3);
 insert into b values(5,5,5);
 
 
 create table c (
 id2 integer,
 c1 integer);
 insert into c values(1,1);
 
 
 --执行报错
select * from  a left join (  select b.id1,c.c1 from b,c where b.id2 = c.id2 )  f on a.id1 = f.id1
 
 
 --变通方法,执行成功
select b.id1,c.c1 from b,c where b.id2 = c.id2 into temp temp2 with no log;

select * from a left join temp2 f on a.id1 = f.id1;


----方法3,结果不对
select a.*,c.c1 from a,outer b , c
where a.id1 = b.id1 
and b.id2 = c.id2

附件：

附件图标 IDS 教程指南.pdf (3.23 MB)