Hello!

I need help on SQL.

There are two tables. Table1 and Table2.

Table1---------------Table2

custid---------------custid,address1
---------------city,state,.....


There are multiple records exist in the table2 for a custid with different address. How do I pick only one record with all the fields.

Thanks In advance....

Ganraj.

------------------
ganraj.

[This message has been edited by ganraj (edited 08-16-1999).]