select t.*
from talk t
where t.user_id = 2
Union
select t.*
from talk t, user_contact c
where c.user_id = 2 and c.contact_type = 1 and c.be_user_id = t.user_id
I don"t want to use Union and I don"t want to weigh it. Is there the easiest way to write it?
hibernate does not support Union
Canbe implemented using inner and left connections?
1.union
2. Send two sql asynchronously and then merge them. The effect is the same as union
give it a try?
select t.* from t left join user_contact c
on t.user_id=c.be_user_id and c.user_id=2 and c.contact_type=1
where t.user_id=2 or c.user_id=2Previous: What does nuxt do, keep-alive?
Next: Vue parent and child components pass an array, neither computed nor watch can trigger
jav inserts Mysql data exception Data too long exception information 2018-04-24 00:15:01 ERROR com.comall.cybershop.common.base.DaoSupport org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update cs_awardCardRe...
select t.* from talk t where t.user_id = 2 Union select t.* from talk t, user_contact c where c.user_id = 2 and c.contact_type = 1 and c.be_user_id = t.user_id it is correct to use Union to write this then use the left connection and I will not write...