mysql常用查询

发布时间：2020-12-29 08:50:31编辑：丝画阁阅读（229）

SELECT * FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id)

SELECT * from dt_finance_receiptpay where pay_id IN(SELECT pay_id FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id))

SELECT * from dt_finance_receiptpaylist where id IN(SELECT id from dt_finance_receiptpay where pay_id IN(SELECT pay_id FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id))
)

SELECT * from dt_audit_deploy where type_id = 23 AND their_id IN(SELECT pay_id FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id))

SELECT * from dt_audit_deploy_lists where deploy_id IN(SELECT id from dt_audit_deploy where type_id = 23 AND their_id IN(SELECT pay_id FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id)))

SELECT * from dt_mobile_dealtlist where their_id IN(SELECT pay_id FROM dt_pay where pay_id NOT IN(SELECT pay_id from dt_pay_parts_list GROUP BY pay_id)) AND type = 'audit_23'