un matching records in tables

The code below extracts the un matching records from c and b
i have to change code so that c.street1 should compare with b.address2 and rest as it is
2nd thing for some records address ,zip might not match but if state matches the data is not extracted for example
Con Table                        Block table
street1  Street2  state   zip          Address1 Address2   state   zip
xyz            nj     08815              Abc          nj     03310


in this case record is not extracted bcos NJ matches in both tables thats not what i was expecting.if any of these columns will not match i should get the record

select
      *
From
      New n
      join Page p On N.ITEM = P.ITEM
      join dbo.Lan l On n.onumber = l.onumber
      Join Con c On c.oId = l.Id
      inner join (
                  select
                        onumber,
                        count(*) as quantity
                  from
                        dbo.Lan
                  group by
                        oNumber
                 ) q on n.ONUMBER = q.onumber
      Left Outer Join block b (NOLOCK) On N.DEALER_ID = b.CUSTNMBR
Where
      n.ORDER_QUANTITY = q.quantity
and	b.address1 is null and  b.ADDRESS2 is null and  b.city is null and b.state is null and b.zip is null

Select allOpen in new window