select код_пред, наименование, город
from таблица1 т1
where код_пред in
(select код_пред
from таблица2 т2
where т1.код_пред = т2.код_пред and дата = 18.05.2013)

select код_пред, наименование, город
from таблица1 т1
where код_пред in
(select код_пред
from таблица2 т2
where дата = 18.05.2013)

create database opt;
go
use opt;
go
create table t1(a int primary key, b int not null, c int check (c between 1 and 50));
create table t2(b int primary key, c int, d char(10));
create table t3(c int primary key);
go
insert into t1(a,b,c) select number, number%100+1, number%50+1 from master..spt_values where type = 'p' and number between 1 and 1000;
insert into t2(b,c) select number, number%100+1 from master..spt_values where type = 'p' and number between 1 and 1000;
insert into t3(c) select number from master..spt_values where type = 'p' and number between 1 and 1000;
go
alter table t1 add constraint fk_t2_b foreign key (b) references t2(b);

use opt;
go
select * from t1 where t1.c in (select t2.b from t2 where t2.c = 10 and t2.b = t1.c);
select * from t1 where t1.c in (select t2.b from t2 where t2.c = 10);

select * from t1 where t1.c in (select t2.b from t2 where t2.c = 10 and t1.c = t2.b);

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4263.0 (X64) 
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 

select код_пред, наименование, город
from таблица1 т1
where exists
(select код_пред
from таблица2 т2
where т1.код_пред = т2.код_пред and дата = 18.05.2013)