I need help inserting ContactID from a contacts (table) into a lead_tracking (table) with the same field name of ContactID.
I need to use some sort of conditional logic to parse out the records that have a ContactID with the ContactStatusID = 2 in the contacts table. With that information I need to have two preset values for two addtional fields in the lead_tracking table that have nothing to do with the contacts table... I hope to god that makes sense because my head is spinning.
See code for my wrong example
INSERT INTO lead_tracking
WHERE ContactStatusID =2
// in addition add a preset values of Lead_typeID = 2 & Lead_progressID = 5 ( into the lead_tracking table)