sql 子查询，多条sql合并

1.

SELECT
*
FROM
order_gtncoin
WHERE
NOT (
(
buy_uid = '13311787'
AND sale_uid = '13319623'
)
OR (
buy_uid = '13319623'
AND sale_uid = '13311787'
)
OR (
buy_uid = '13311787'
AND sale_uid = '13311787'
)
OR (
buy_uid = '13319623'
AND sale_uid = '13319623'))

 

2.

SELECT *FROM order_gtncoin WHERE
id NOT IN (SELECT id FROM order_gtncoin WHERE
(buy_uid = 13311787 AND sale_uid = 13319623)
OR(buy_uid = 13319623 AND sale_uid = 13311787)
OR(buy_uid = 13319623 AND sale_uid = 13319623)
OR(buy_uid = 13311787 AND sale_uid = 13311787));

结果都是一样的两种方法