Search results

I have two tables -- both have Surname, First name, Middle Name fields. I want to build a query where I can compare the records in tableA with the records in tableB where the Surname in A is "like" the Surname in B. The "like" is important, because I am dealing with potentially different...

Thanks Pat -- that works -- I was hoping to build a killer query that would do it all at once, but. Now my tables are populated! Thanks again. LAF

I'm trying to take a flat database (all records in one table) and make it relational. The flat table contains contact information, phone, address, customer type etc. information, and I want to pull these out to appropriate tables ie. address table, phone table. There is no primary key on the...