sql inner join for efficiency.