Select * From T_alocate A Where exists ( Select * From M_tag M Where A.tagid=M.tagid and M.name Like '%AKB%' )