sql查询不重复记录，多表之间查询

1.搜索不重复数据

select distinct user_id,event_id from bm_shoucang

2.三表联合查询

SELECT * FROM (bm_shoucang INNER JOIN bm_user ON bm_shoucang.user_id=bm_user.id) INNER JOIN bm_relese_event ON 

bm_shoucang.event_id=bm_relese_event.id WHERE bm_user.id= 19

3.两表查询

SELECT * FROM bm_shoucang a,bm_relese_event b WHERE a.event_id=b.id AND a.user_id=19

4.两表联合查询不重复数据

SELECT distinct a.user_id,a.event_id,b.* FROM bm_shoucang a,bm_relese_event b WHERE a.event_id=b.id AND a.user_id=19

就是把1和3合成一句 效率也挺高