View Single Post
  #2  
Old 2007-07-05, 19:38
brady4747 brady4747 is offline
Junior Member
 
Join Date: 2007-06
Posts: 23
Default Re: Datastore sql statement questions

OK, I succesfully put the JOIN in the selectdatasql:

Quote:
SELECT %N FROM contacts LEFT JOIN company on contacts.idcompany = company.idcompany WHERE idcontact=%k AND folderkey=%f
and put the company.company_name in the fieldmap for ORG_NAME and it syncs to device fine. I guess I need to set the ORG_NAME to r instead of rw though in case of changes on client
Reply With Quote