Okay,
3 joined updates same format, first 2 work last one doesn't can't for the life of me figure out why.
1.This works
2.This works
3.This only returns an empty set
While this Works
And this works
So what gives???
3 joined updates same format, first 2 work last one doesn't can't for the life of me figure out why.
1.This works
Code:
UPDATE contacts, campaign_log SET contacts.invalid_email=1 WHERE contacts.id=campaign_log.target_id AND campaign_log.activity_type="invalid email"
Code:
UPDATE campaign_log, contacts SET campaign_log.deleted=1 WHERE contacts.id=campaign_log.target_id AND contacts.agency_name="FSBO"
Code:
UPDATE campaign_log, emails SET campaign_log.activity_type="invalid email" WHERE campaign_log.related_id = emails.id AND emails.description_html = "X"
Code:
UPDATE campaign_log, emails SET campaign_log.activity_type="invalid email" WHERE campaign_log.related_id = emails.id
Code:
SELECT*FROM emails WHERE emails.description_html = "X"
Comment