不知道楼主想要什么结果,试一下下面的 SELECT A.a,b=(SELECT TOP(1) b FROM TABLEB WHERE pk=A.bpk) FROM TABLEA AS A SELECT A.a,B.b FROM TABLEA AS A INNER JOIN TABLEB b ON b.pk=A.bpk
除了cross join,其他join都要有on条件
不如直接这样select a.a,max(b.b) from a left join b on a.bpk=b.pk group by a.a
SELECT A.a,b=(SELECT TOP(1) b FROM TABLEB WHERE pk=A.bpk) FROM TABLEA AS A SELECT A.a,B.b FROM TABLEA AS A
INNER JOIN TABLEB b ON b.pk=A.bpk
http://www.cnblogs.com/shpchan/archive/2010/04/13/1710972.html