求教一个mysql语句 select a.column1,tmp.column1 from a ,(select * f

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/29 07:33:05

求教一个mysql语句 select a.column1,tmp.column1 from a ,(select * from b where ...) where ...
求教一个mysql语句
select a.column1,tmp.column1 from a ,(select * from b where ...) as tmp where ...
tmp相当于从另一个表查询出的结果建立的子表
求教怎么才能让这个子表引用外面的表的字段
就是 ..(select * from b where a.id = b.aid ) as tmp ...

select a.column1,tmp.column1 from a ,(select * from b where ...) where ...
中(select * from b where ...) temp (别名)
再问：看我补充我想引用外面的表的字段
再答：应该你把as去掉，写成这样就可以了
再问：不行跟那个没关系 Unknown column 'xxx' in 'where clause' 你运行可以？给个完整的例子
再答： select a.column1,temp.column2 from a,(select a.column2 from a) temp

insert into a select * from b 和select * into a from b 这两个语句是 SQL语句理解 select * from B where (select count(1) as num from A select * from a union select * from b 能详细说下么请问大侠,我要在function（）下写一个动态sql语句,如select * from A WHERE name in select * into b from a where 11 select ** from A where A.id in (select id from B where ****) select top 10 * from (select top 40 * from a order by id asc select * from (select * from 表名) 这样的语法中括号里的查询语句是什么意思.为什么不直接f Select a username是什么意思 to select a Select a password是什么意思? Select a country是什么意思