But using LEFT JOINS is just the way I have always done it because that is the way I look at the problem in my head. The SQL engine doesn't care. I was wondering why you were trying to use a CROSS ...