
February 5th, 2012, 10:52 PM
|
 |
Contributing User
|
|
|
|
|
INSERT SELECT if not exist
I want this query only if the value does not already exist.
How can I do that?
Thanks
Code:
INSERT
INTO cms_job_attachments_view (job_id, member_id)
SELECT cms_job_group.job_id AS JID
, GROUP_CONCAT( cms_members.id SEPARATOR ',')AS MEMEBRS_IN_GROUP
FROM cms_members
INNER
JOIN cms_group_members ON cms_members.id = cms_group_members.member_id
INNER
JOIN cms_group ON cms_group.id = cms_group_members.group_id
INNER
JOIN cms_job_group ON cms_job_group.group_id = cms_group_members.group_id
WHERE cms_job_group.job_id =1 AND cms_members.id <>12
GROUP BY member_id";
|