sql的A表筛选后怎样根据两张表相同的ID关联B表呢？

[chauncy_win]

sql的A表筛选后怎样根据两张表相同的ID关联B表呢？



例如：

A表：id
select * from dweller where buy ='否' and (type='第一'or type='第二'or type='第三')


B表：id

[吉普赛的歌]

--1.
SELECT * 
FROM 
(
	select * from dweller where buy ='否' and (type='第一'or type='第二'or type='第三')
) AS A
INNER JOIN B
    ON A.id=B.id
    
    
--2. 推荐写法
select * from dweller AS A
	INNER JOIN B ON A.id=B.id 
where A.buy ='否' and (A.type='第一'or A.type='第二'or A.type='第三')