where two fields in subquery???

[m0nkey]

hi...
i was hoping for a little help with a quey that is presumably an easy write but it is missing me right now...
here is the query i would like to run but it is incorrect obviuosly:

select distinct npa_nxx_id, zipcode, city, state
from npanxx
join zipusa on zipusa.zipcode = npanxx.zipcode
where npa_nxx_id, zipcode in
(select npanxx,zipcode from npa_zip)

My problem is that i need to qualify on the two of the columns in the subquery to make this work...

any ideas...
thanks in advance...
mark

 

[checkai]

select distinct npa_nxx_id, zipcode, city, state 
from npanxx 
join zipusa on zipusa.zipcode = npanxx.zipcode
inner join npa_zip z on npanxx.npa_nxx_id = z.npanxx AND
npanxx.zipcode = z.zipcode

would this work?

 

[m0nkey]

That worked perfect...i knew it was something simple, but i was brainfarting...thanks for the help!!!!!