result set

clientname                     contactname  phone  billingaddress1 billingcity billingstate billingzip

xx Enterprises, LLC Jaon smith (555)555-1528  445 Marks St. somewhere NV 55555

sample data for contactmethods would be

 2308 1 Phone (555)555-1820  8/2/2004 9:53:00 AM jhkhj 8/2/2004 9:53:00 AM dfgdfg 

for clients

 8909 454545 rere Country Club Client  joan smith ddd2403$&amp

okay how can I do that? so I can send you...

how can I get rid of cursors and just go by while loop