mysql查詢三門課程,Mysql怎樣求對同一個表的多個查詢的交集?
查詢1:
select * form A where keywords like '%小貓%'
查詢2:
select * form A where keywords like '%小狗%'
select * from 查詢1 a inenr join 查詢2 on a.keywords=b.keywords
查詢1:
select * form A where keywords like '%小貓%'
查詢2:
select * form A where keywords like '%小狗%'
select * from 查詢1 a inenr join 查詢2 on a.keywords=b.keywords