怎么写一个相关子查询语句？

[飞火流星02027]

--有两个表:
CREATE TABLE [dbo].[T_ZLLR_ZLXX] (  --A
     C_MYID varchar PK
     N_ZLID int  --
     N_ZLLX int   --
	[C_TGMC] [varchar] (100) 
	[C_GJZ] [varchar] (50)
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_GPGL_GPTGMX] (  --B
     C_GPID varchar PK
     N_ZLXH int
     N_ZLLX int  --
	 N_ZL int    --
) ON [PRIMARY]
GO

T_ZLLR_ZLXX A, T_GPGL_GPTGMX B

怎么写查询:
查询B表的N_ZL,N_ZLLX两个字段与A表中两字段N_ZLID,N_ZLLX相等的记录
select * from T_ZLLR_ZLXX a
where a.N_ZLID in (select N_ZL from T_GPGL_GPTGMX b where C_GPID='20091014111610003') and a.N_ZLLX=b.N_ZLLX
上面是我写的，有语错误

[SQL77]

SELECT * FROM A WHERE EXISTS(SELECT 1 FROM B WHERE A.N_ZL=N_ZL AND A.N_ZLLX=N_ZLLX)

[--小F--]

select * from a where exists(select 1 from b where A.N_ZL=N_ZL AND A.N_ZLLX=N_ZLLX)

[qiqi860819]

select * from a inner join b on a.N_ZLID=b.ZL and a.N_ZLLX=b.N_ZLLX