<![CDATA[BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog]]>

<![CDATA[BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog]]> http://www.bizeway.net/index.php zh-cn http://www.bizeway.net/read.php? <![CDATA[关于select的嵌套用法]]> ArthurXF <arthurxf@gmail.com> Tue, 05 Jun 2007 09:46:46 +0000 http://www.bizeway.net/read.php?

引用

select A from (select * from tableB) as t1
或者
select A from (select * from tableB) t1

例子：

引用

SELECT *
FROM (
SELECT *
FROM affiche
ORDER BY `submit_date` DESC
) AS t1
GROUP BY type_id
ORDER BY `submit_date` DESC
LIMIT 0 , 30

如果要从表userinfo(此表也含有userid)中选出与表result的userid不同的所有数据，例子如下：

引用

select * from userinfo where userinfo.userid not in(select result.userid from result)

Tags - select , sql , 嵌套 ]]> http://www.bizeway.net/read.php?&guid=0#topreply <![CDATA[[评论] 关于select的嵌套用法]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://www.bizeway.net/read.php?&guid=0#topreply