update  `comp_journal_detail` 
set acctcode = 32909
WHERE companyid=3 
and`journalID` LIKE 'AP20150800000031' 
and acctcode = 32535; 

select distinct a.supplierid,b.ID,  b.supplierName, b.linkedapaccountid from comp_supplier_invoice a, supplier b
where a.journalno in (select distinct journalid from comp_journal_detail where acctcode = 32535) 
and a.supplierid = b.id


-- select jd.journalid, jd.acctcode, jd.formno, jd.supplier, s.linkedapaccountid from 
-- update
comp_journal_detail jd, comp_payment p, supplier s
-- set jd.acctcode = s.linkedapaccountid
where jd.journalid = p.journalno
and p.supplierid = s.id 
and jd.acctcode = 32535

-- select jd.journalid, jd.acctcode, jd.formno, jd.supplier, s.linkedapaccountid from 
update
comp_journal_detail jd, comp_supplier_debitnote p, supplier s
set jd.acctcode = s.linkedapaccountid
where jd.journalid = p.journalno
and p.supplierid = s.id 
and jd.acctcode = 32535

-- select jd.journalid, jd.acctcode, jd.formno, jd.supplier, s.linkedapaccountid from update comp_journal_detail jd, comp_supplier_creditnote p, supplier s set jd.acctcode = s.linkedapaccountid where jd.journalid = p.journalno and p.supplierid = s.id and jd.acctcode = 32535