SELECT
    comcon.id,
    comcon.title,
    comcon.statusid,
    con.id,
    con.firstname,
    con.lastname,
    con.statusid
FROM
    `companycontact` comcon
INNER JOIN `contact` con ON
    con.id = comcon.contactid
WHERE
    con.statusid = 2;

UPDATE companycontact
INNER JOIN `contact` ON
    contact.id = companycontact.contactid
SET companycontact.statusid = 2
WHERE
    contact.statusid = 2

FK_invoicecustomitem_chargecategoryid

ON DELETE
RESTRICT
ON UPDATE
RESTRICT

chargecategoryid
+ Add column	
bzb

chargecategory

Do you really want to execute "ALTER TABLE bzb.invoicecustomitem DROP FOREIGN KEY FK_invoicecustomitem_chargecategoryid;"?
OKCancel