select * from tbl_Lib_Companies where companyPType = 'MFR' and companyPKeyId = select * from tblMfrBrokerLink mbl where mbl.mfr_id = select * from tbl_PRD_SKUs s where s.fsl_tablecode = 'BRO' and s.mfrId = select * from tbl_BRO_Principals p where p.mfrId = and p.ownerType = 'BRO' select * from tbl_SMA_BrokerOfficeLink sma where sma.mfr_id = select * from tbl_BRO_principalCompetitors pc where pc.mfrId = and pc.ownerType = 'BRO' UPDATE tblManufacturers SET crmActive = 'N', crmActiveUserId = 156659, crmActiveDate = #CreateODBCDateTime( Now() )# WHERE MFR_ID =