inner join 和 in 实例

为什么80%的码农都做不了架构师？>>>   

delete from campaigns_keyword where campaigns_keyword.id in (SELECT
	keyword.id
	FROM(
		select campaigns_keyword.id,
		campaigns_keyword.name,
		campaigns_keyword.cid,
		campaigns_keyword.adgroup_id
		from campaigns_keyword where campaigns_keyword.name='a') as keyword
	inner join (
		select campaigns_adgroup.id,
		campaigns_adgroup.name,
		campaigns_adgroup.campaign_id
		from campaigns_adgroup where campaigns_adgroup.name='原理B' )as adgroup 
	ON keyword.adgroup_id = adgroup.id
	inner join(
		select
		campaigns_campaign.id,
		campaigns_campaign.name,
		campaigns_campaign.account_id
		from campaigns_campaign where campaigns_campaign.name ='电脑品_c2') as campaign
	on adgroup.campaign_id=campaign.id
	inner join(
		SELECT configs_account.id,
		configs_account.name
		FROM configs_account where configs_account.name ='mt_baidu') as account
	on campaign.account_id = account.id)

转载于:https://my.oschina.net/hcp/blog/41887