Question

关于ASP SQL的多表查询语句

现有2个表，A表和P。A表（相册表）如下：ID，NAME，USER。P表（照片表）如下：ID，NAME，USER，AID。P表（照片表）属于A表（相册表）的的子栏目类型，AID就是P的ID，用户可以添加照片，必须要选择属于哪一个相册。我能查询出所有的相册表 select * from [A] order by id desc 。现在的问题是如何用一条语句查询照片表中要有照片的相册出来？现在我用的2条语句来实现的

set rs = Server.CreateObject("ADODB.RecordSet"):rs.cursorlocation=3
rs.Open "select * from [A] order by id asc",conn,1,1

set rsP = Server.CreateObject("ADODB.RecordSet"):rsP.cursorlocation=3
rsP.Open "select * from [P] where PID="&rs("ID")&" order by id asc",conn,1,1

谢谢！

Answer 1

select 'mid1' as tle,title,content from mid1 where title like '%你好%' or content like '%你好%'
union all
select 'mid2' as tle,title,content from mid2 where title like '%你好%' or content like '%你好%'
union all
select 'left2' as tle,title,content from left2 where title like '%你好%' or content like '%你好%'

一定要用union all，否则相同项就合并到一起了

Answer 2

select * from [A] where exists(select * from [P] where [P].AID=[A].ID) order by id desc

Answer 3

看了半天还是不明白你的意思

举个例子多简单呢