cross apply的疑问

[文盲老顾]

select * from table1 a
cross apply(
  select top 1 * from table2 where pkid=a.pkid
) b

在不使用join方法时，使用cross apply可以对数据进行关联查询，现在有一个疑问

当cross apply中的子查询没有结果时，table1的数据也不会被查询到，除了union一个null行和join方法，有没有其他方法可以让 cross apply的内容无结果时不影响主表查询结果？

[吉普赛的歌]

SELECT t.name AS tableName,c.name AS columnName FROM sys.tables AS t OUTER APPLY(
	SELECT * FROM sys.[columns] AS c WHERE c.[object_id]=t.[object_id]
	AND 1=0
) AS c

换 outer apply

[吉普赛的歌]

left join 也可以

SELECT t.name AS tableName,c.name AS columnName FROM sys.tables AS t LEFT JOIN (
	SELECT * FROM sys.[columns] AS c WHERE 1=0
) AS c ON c.[object_id]=t.[object_id]

[听雨停了]

楼上说的换outer apply就可以啦