Try using an INNER join if you only want those rows were xx.colb = 8