We have two table company and people and people has coid as a foreign key. I need to select 10 contacts or less for each company randomly.
Below are the structures:
Company - CoID, Company, address, street, city, state, postcode, country, phone, fax, addedby, addedon, editedby, editedon
People- PersonID, CoID, Firstname, lastname, title, persontype, email, addedon, addedby, editedon, editedby
Thanks for your help, please get me started