Require query to transfer data from Sugarcrm to tailor made system
Posted on 2011-02-23
I need a query that will tranfer the data from one table into another one, I have work on this for a bit, but I am getting stuck and frustated (I am not a programer).
If you are familier with sugarcrm it contains
1. The account or cllient table
2. The Contact Table
3. and a table that stores the id values for contact and accounts that are link to each other.
I have created a new table for contacts on my tailor made system and I need to
copy the "accountid" into the table of "contacts" from the table "number 3". where "contactid" in table "number 3" is = "ContactID" on the "contact table" I have tryed diferent sql queries but I alway get the duplicate id error or the row returns more than one ?????. I can not pass this point the error I get is one or the other one.
Contact table =
and I have created a new field called "companyID" where the new values need to be stored.
Link table =
I really had enough of spending hours looking for a solution on line, can someone please
write a query that I can put into PHPmyadmin to copy the values over?
For me this question is very difficult as I have been on it for some time now.