SELECT RecordID, Organization, AddressLine1, AddressLine2, AddressLine3, AddressLine4, AddressLine5, AddressLine6, AddressLine7, AddressLine8, DependentLocality, DoubleDependentLocality, Locality, SubAdministrativeArea, AdministrativeArea, SubNationalArea, PostalCode, Country FROM dbo.ttAddress WHERE NOT EXISTS (Select RecordID from dbo.ttAddressResponse where RecordID = dbo.ttAddress.RecordID);