一串失败的代码，但是很有借鉴的意义

select LicensePlateNumber,FrameNumber,EngineNumber from vehicle where id in 
	(select VehicleId from device where IMSI in 
		(select IMSI from weixin where FromUserName='ooXyYjmKVbL-W7kpyhbv4OSsTiFU' 
			union 
		select imsi from sim where phoneNumber in (select IMSI from weixin where FromUserName='ooXyYjmKVbL-W7kpyhbv4OSsTiFU')
		)
	)