select
	a.*,
	b.*
FROM
	(SELECT * from tblA WHERE SomeCol <> 'PA') AS a
	JOIN
		tblB
	ON	 a.SomeCol = b.SomeCol
OPTION ( FORCE ORDER)

select	
	w.Unidade, 
	w.Data, 
	w.Interface, 
	w.NomeInterface
	
from ( 
	select 
		c.unidade, 
		c.Data, 
		c.Interface, 
		c.NomeInterface
	from cad_interface c 
	inner join sam.dbo.Unidade u 
		on (c.unidade = u.codigounidade) 
	where left(interface,6) = 'Inform' 
		and unidade = 999 
		and data between 20120701 and 20120702 
) as w
  
left outer join ( 
	select 
		dataint Data, 
		left(nomeint,11) COLLATE Latin1_General_CI_AS 'Interface',  
		SUBSTRING(nomeint,4,2) Unidade
	from openquery(BS,'select * from PDTABLE') 
	where SUBSTRING(nomeint,1,1) = 'P'  
) as b 
	on (w.data			= b.data 
	and w.unidade		= b.Unidade
	and w.nomeinterface	= left(b.interface,8)) 
	  
order by w.data, w.unidade

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass