> I'm sure rudy will swoop in and save the day any sec now... already been saved, by tab it's a union, not a join but thanks for the nice thought ;o) <tip type="MySQL"> Debunking GROUP BY myths http://rpbouman.blogspot.com/2007/05/debunking-group-by-myths.html </tip>