I'll check the syntax when I get back to my office in 30 mins or so....

>I get a syntax error. do you see any problems with the SELECT?
>
>>SELECT taddress.*,tcustomer.custname AS custcustname FROM taddress LEFT INNER JOIN tcustomer ON taddress.custnum = tcustomer.custnum WHERE taddress.custname # tcustomer.custname
>
>>The result set will be one record per address record that does not match it's parent's custname value.
>
>
>>>Have two tables, lets say tcustomer and taddress. Each tcustomer can have many taddress. The unique custnum is in both tables. taddress also has addrseq to make it unique. Unfortunately custname is in both tables (bad design), and some bug has allowed the tcustom.custname to not equal taddress.custname for the same custnum.
>>>
>>>Want an SQL to find all the records in taddress where the custname does not match tcustomer.custname? Tried
>>>
>>>select obligat.name from obligor obligat where obligor.obligor = obligat.obligor and obligor.name <> obligat.name
>>>
>>but I guess the one to many of the table relationship makes it return an empty result set.
>>>
>>>Any help is appreciated.
>>>
>>>Brenda